title: SQL avg then trailing numbers
body: <p>I'm trying to get the average number, and then remove the trailing, pointless zeros afterwards, (new to SQL) but I can't understand why it wont remove them, do I have the wrong idea??</p>
  
  <p>So far I have;</p>
  
  <pre><code> SELECT total,
   AVG(total(TRUNCATE(total/1,2))
  </code></pre>