title: convert integer to float /decimal
body: <p>the output should be as </p>
  
  <pre><code>totalsales
  
  250.0000
  </code></pre>
  
  <p>code:</p>
  
  <pre><code>select cast(max (totalsales) as float())
  from (select SalesPerson, avg(TotalSale) AS totalsales
  from Sales 
  group by SalesPerson);
  </code></pre>
  
  <p>current output is as 250.0 need as 250.0000</p>
  
  <p>TotalSale datatype is integer</p>
  
  <p>Table Sales:</p>
  
  <pre><code>InvoiceNo   SalesPerson TotalSale
  
  1           Acheson      50    
  2           Bryant       25    
  3           Bennett     250    
  4           Acheson      50    
  5           Bryant      100    
  6           Bennett     250
  </code></pre>