SQL AVG - SQL Tutorial
The SQL AVG aggregate function selects the average value for certain table column.
Have a look at the SQL AVG syntax:
If we want to find out what is the average SaleAmount in the Sales table, we will use the following SQL AVG statement:
SELECT AVG(SaleAmount) AS AvgSaleAmount
which will result in the following dataset: