SQL Quest › SQL Interview Questions › Aggregation & Grouping
Quality Grade Distribution
How many products are in each quality grade (L=low, M=medium, H=high)? Show type, product_count. Order by product_count descending.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".
Schema
products
| udi | product_id | type | tool_wear_min |
|---|---|---|---|
| 5640 | L52819 | L | 180 |
| 2171 | M17030 | M | 10 |
| 228 | L47407 | L | 168 |
Expected output: Per-grade product counts
Hint
GROUP BY type with COUNT(*).
Concepts
SELECT GROUP BY Aggregation
Practise the topic: SQL practice questions · GROUP BY exercises
Related questions
Counting RowsEasy · FreeSUM, AVG, MIN, MAXEasy · FreeGROUP BY BasicsEasy · FreeMonthly Order CountEasy · FreeHow Many Genres Do We Cover? (DISTINCT)Easy · FreeFemale Survivor CountEasy · Free
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test