intermediateDatabase448 of 469
Write a query using WHERE, GROUP BY and HAVING.
Tests whether you correctly sequence the three -- WHERE to filter rows before grouping, GROUP BY to aggregate, HAVING to filter the resulting groups -- a common query-writing exercise that reveals whether the execution order concept actually sank in.
Ready to master this question?
Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.
Sign in to generate a response