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.
Answer business questions straight from the database: joins, aggregates, window functions and queries you can trust.
Lesson 3 of 4 · 13 min