AVG

An aggregate that returns the arithmetic mean of the non-NULL values in a group.

In more detail

It always returns a floating-point number in SQLite, even over integers, so format it for display outside the query. Because NULLs are skipped, the mean is over the values present, not over all rows.

Related terms

Taught in

References