Question

Mysql query to find highest average sales among all the salespersons

Answer 1

hey mate : )

=========================

The syntax for finding the average of any values in a table is as follows:

SELECT AVG(column_name)

FROM table_name;

Now for the given table ‘Sales’,

InvoiceNo SalesPerson TotalSale

     1                    Acheson       50

     2               Bryant       25

     3               Bennett     250

     4             Acheson       50

     5               Bryant      100

     6             Bennett      250

The following will find the average of the total sales.

SELECT AVG(TotalSale)

FROM Sales;

Output: 120.833  

============================

hope it helps ^_^