AVG

Compute the average.

AVG returns the average of a column. It ignores NULL values.

SELECT AVG(price) FROM products;

This query gives the average price.

AVG(price) is selected from products.

AVG — details

AVG divides the sum by the row count. NULLs are excluded from both sum and count.

For example, the average of 10, 20 and NULL is 15 (30 / 2); to count NULL as 0 you write AVG(COALESCE(price, 0)).

Compute the average price in products with AVG(price).

Show example solution

SELECT AVG(price) FROM products;

Add AVG

SELECT ____(price) FROM products;

Show answer

SELECT AVG(price) FROM products;

Next lesson: MIN and MAX