GROUP BY with aggregates

Use COUNT, SUM and friends with groups.

GROUP BY and aggregates

With GROUP BY you apply COUNT, SUM, AVG to each group.

SELECT category, SUM(price)
FROM products
GROUP BY category;

This query gives the total price per category.

category, SUM(price) is selected from products. Rows are grouped by category; aggregate functions are computed per group.

One aggregate row per group is produced. You can use AVG, MIN, MAX instead of SUM.

For example, SUM(price) gives each category's total value, while MAX(price) gives the price of the most expensive product in it.

Compute the total price per category with SUM(price).

Show example solution

SELECT category, SUM(price)
FROM products
GROUP BY category;

Add SUM

SELECT category, ____(price)
FROM products
GROUP BY category;

Show answer

SELECT category, SUM(price)
FROM products
GROUP BY category;