Aggregate Functions
Aggregate Functions: Calculations vs Aggregations, Common Aggregate Functions, Grouping Aggregations.
Updated
- Calculations vs Aggregations (Apprentice): The difference between a calculation, which works on the values in one row, and an aggregate function, which turns many rows into one value.
- Common Aggregate Functions (Apprentice): What COUNT, SUM, AVG, MIN and MAX return, and how each one treats NULL values.
- Grouping Aggregations (Journeyman): How GROUP BY returns one aggregate row per group, and how HAVING filters those groups where WHERE filters rows.