Lesson 2 of 3 · 10 min

Counting & summarising

COUNT, SUM, AVG, MIN and MAX turn many rows into one answer.

GROUP BY summarises per category: SELECT city, COUNT(*) FROM customers GROUP BY city.

Practice

Write a query that counts orders per customer.

Optional resources

No purchase or partner signup is required to complete this course or earn quiz points.

These are official product links, not active affiliate links. Learnly does not currently earn a commission from them.

Explore guided SQL exercises alongside your queries.

Limited free content; full course access may require payment.

Test small SQL examples using fictional sample data.

Browser SQL playground; never paste private or personal data.