Summary - Aggregates

Write a summary report with COUNT, SUM, AVG, MIN and MAX.

COUNT, SUM, AVG, MIN and MAX produce summary values on a column. NULLs are skipped.

SELECT COUNT(*), SUM(price), AVG(price)
FROM products;

Summary aggregate query.

COUNT(*), SUM(price), AVG(price) is selected from products.

Exercise Summary - Aggregates

Summary: compute COUNT(*) and SUM(price) on products.

Show example solution

SELECT COUNT(*), SUM(price) FROM products;

Next lesson: Sales design