SQL AVG

The SQL AVG aggregate function selects the average value for certain table column.

Have a look at the SQL AVG syntax:


SELECT AVG(Column1)
FROM Table1

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
FROM Sales

which will result in the following dataset:

AvgSaleAmount
$195.73