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
Answers
Answered by
0
TypeInvoiceNo IntegerSalesPerson TextTotalSale IntegerSampleInvoiceNo SalesPerson TotalSale1
Answered by
0
Answer:
select max(t) from (select avg(totalSale) as t from Sales group by Salesperson) as tb;
Explanation:
Similar questions