avg()

Takes the average of row values in a given column.

avg() follows this syntax.

SELECT avg(COLUMN_NAME)
FROM DATASET
WHERE CONDITION;