Concept
GROUP BY and aggregate functions
Collapsing rows into groups and computing COUNT, SUM, AVG, MIN and MAX per group, filtered with HAVING.
Part of SQLGROUP BY and aggregate functions
Then learnWindow 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
- SQL Interview Questions for Freshers4 questions on GROUP BY and aggregate functions
- Intermediate SQL and MySQL Interview Questions1 question on GROUP BY and aggregate functions
- Find Duplicate EmailsCoding problem · easy
- Highest Paid Employee in Each DepartmentCoding problem · medium
- Daily Sales Running TotalCoding problem · medium