learn deep. ship safe.Practice testsFollow ByteMunSubscribe

Concept

GROUP BY and aggregate functions

Collapsing rows into groups and computing COUNT, SUM, AVG, MIN and MAX per group, filtered with HAVING.

Concept map
Part of SQLGROUP BY and aggregate functions

What to learn after GROUP BY and aggregate functions

  • Window functionsWindow functions extend aggregates to run over related rows without collapsing them.

Connections to other concepts

Part of
SQL

Practise GROUP BY and aggregate functions

All topics