title: Finding average highest salary
body: <p>Write a query to find the highest average sales among all the salespersons using the given table.</p>
  
  <pre><code>Table: Sales
  
  Field       Type
  InvoiceNo   Integer
  SalesPerson Text
  TotalSale   Integer
  </code></pre>
  
  <p>Sample</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>
  
  <p>Sample output</p>
  
  <pre><code>max(totalsale)
  250.0000
  </code></pre>
  
  <p>I tried using: <code>SELECT MAX(TotalSale) FROM Sales</code>. My output for sample test case was 250 but it was given wrong answer verdict in an online judge.
  Also, when I changed the query to : <code>SELECT MAX(TotalSale*1.0000) FROM Sales</code>,I got correct answer for sample test case but still wrong answer for other test cases.</p>
  
  <p>What is meant by average here? What should be the query?</p>
  
  <p>Also, this isn't from any on-going competition. It is from a practice test which you can attempt here:  <a href="https://www.hackerearth.com/challenge/test/kredx-data-analyst-test/" rel="nofollow noreferrer">https://www.hackerearth.com/challenge/test/kredx-data-analyst-test/</a></p>