#aggregations

SQL Aggregations: COUNT, SUM, AVG, GROUP BY, HAVING

Summarise data the right way — COUNT, SUM, AVG, MIN, MAX, GROUP BY across one or many columns, and the WHERE vs HAVING distinction that catches everyone the first time.