The best video to learn SQL GROUP BY and HAVING
5:08Best pick · Sep 17MySQL: GROUP BY
This concise 5-minute tutorial from late 2022 directly matches your request by using a sales transactions table to demonstrate data aggregation. It clearly walks through grouping by order dates and customer IDs to calculate metrics like total daily sales using SUM, COUNT, and AVG. Crucially for beginners, it demonstrates why WHERE fails on aggregated data and how to correctly filter those groups using the HAVING clause.
Not quite what you need?The close runners-up, by what they do better
Pro2 more videos made the shortlist. Pro shows them, so you can overrule us.
After you watch
A few questions written from what the video actually says, each graded with a short why.
This video first, then the lessons that come after it, each with a quiz.
How they compared
Every one of the 10 candidates, scored and judged in one table.
Unlock with ProWe compare the real candidates and tell you which one, and why.