Project 20: High-Volume Sales Plans
SQL Architect
Builds on these lessons
Query Task
Objective
HAVING filters groups AFTER GROUP BY has summarized them — WHERE can't do this, since WHERE filters individual rows before grouping ever happens.
You're given a sales table with columns id, plan, and amount.
Task: write a query returning plan and a count of sales, grouped by plan, keeping only groups with more than 100 sales.
query.sql
SELECT plan, COUNT(*) FROM sales GROUP BY plan HAVING COUNT(*) > 100;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results