SQL uses the AVG() function to calculate the average of a column.

The syntax for using this function is;

SELECT
AVG(“column_name”)
FROM
“table_name”

For example, if we want to get the average of all sales from the following table:

Store Sales Information

you would type in”

SELECT
AVG(Sales)
FROM
Store_Information

Result:
AVG(Sales) = $687.5

$687.5 represents the average of all Sales entries: ($1500 + $250 + $300 + $700) / 4.