SQL AVG FUNCTION

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

MORE BASIC SQL COMMANDS