Group by and aggregation quiz
Counting rows vs values, sums, averages and nested group operations.
Revise first: Group by with several aggregations, All Rows grouping and per-group calculations, Group by several keys and sort the output, Group consecutive rows with GroupKind.Local