What is GROUP BY?

Group rows by a column.

GROUP BY groups rows by a column. One row is produced per group.

SELECT category, COUNT(*)
FROM products
GROUP BY category;

This query gives the product count per category.

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

What is GROUP BY? — details

GROUP BY works with aggregate functions. COUNT, SUM, AVG are applied per group.

For example, SELECT category, COUNT(*) FROM products GROUP BY category gives the number of products in each category on one row.

Group products by category and count.

Show example solution

SELECT category, COUNT(*)
FROM products
GROUP BY category;

Add GROUP BY

SELECT category, COUNT(*)
FROM products
____ category;

Show answer

SELECT category, COUNT(*)
FROM products
GROUP BY category;