Lesson 11 of 20
Group with GROUP BY and HAVING
Calculate an indicator by category, city or status, then filter the resulting groups.
22 minSQL Essentials
By the end of this lesson
- Set the level of detail with GROUP BY
- Distinguish between WHERE and HAVING
- Build a readable aggregate ranking
SQL Essentials
Unlock this lesson and continue the path.
Group with GROUP BY and HAVING is part of the complete programme: 20 lessons, 44 verifiable exercises and 2 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge