Kestrel Learn
All courses
DataIntermediate · 4 lessons · 55m

Practical SQL for Analysts

Answer business questions straight from the database: joins, aggregates, window functions and queries you can trust.

Lesson 3 of 4 · 13 min

GROUP BY and aggregates

Count, sum and average by customer, week and region. We also cover HAVING and why filtering after grouping is different from filtering before.
Next: Window functions

Add a lesson