Aggregate Functions

Aggregate Functions: Calculations vs Aggregations, Common Aggregate Functions, Grouping Aggregations.

Updated

  1. 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.
  2. Common Aggregate Functions (Apprentice): What COUNT, SUM, AVG, MIN and MAX return, and how each one treats NULL values.
  3. Grouping Aggregations (Journeyman): How GROUP BY returns one aggregate row per group, and how HAVING filters those groups where WHERE filters rows.