AVG

An aggregate function returning the average of non-NULL numeric values.

What is AVG in a relational database?

AVG — An aggregate function returning the average of non-NULL numeric values.

SELECT customer_id, AVG(total_amount) AS average_total
FROM purchase_order
GROUP BY customer_id;

Level: Apprentice · More Database terms at this level

Updated September 28, 2026