Question

Write a query to find the highest average sales among all the salespersons using the given table.Sample inputTable: SalesField TypeInvoiceNo IntegerSalesPerson TextTotalSale IntegerSampleInvoiceNo SalesPerson TotalSale1 Acheson 502 Bryant 253 Bennett 2504 Acheson 505 Bryant 1006 Bennett 250Sample outputmax(totalsale)250.0000

Answer 1

TypeInvoiceNo IntegerSalesPerson TextTotalSale IntegerSampleInvoiceNo SalesPerson TotalSale1

Answer 2

Answer:

select max(t) from (select avg(totalSale) as t from Sales group by Salesperson) as tb;

Explanation: