| 1SELECT, column lists, * |
55 / 20 |
100% |
| 2WHERE, numeric comparison |
5 / 20 |
25% |
| 3WHERE, string literals and quoting |
6 / 20 |
30% |
| 4AND, OR, IN, BETWEEN, != |
6 / 30 |
20% |
| 5IS NULL, IS NOT NULL |
2 / 20 |
10% |
| 6ORDER BY, LIMIT, DISTINCT |
10 / 30 |
33% |
| 7COUNT(*) vs COUNT(col) |
2 / 20 |
10% |
| 8GROUP BY with COUNT |
7 / 30 |
23% |
| 9SUM, AVG, MIN, MAX with GROUP BY |
16 / 30 |
53% |
| 10HAVING |
10 / 30 |
33% |
| 11Inner join |
9 / 30 |
30% |
| 12Inner join + aggregate |
5 / 30 |
17% |
| 13Left join |
9 / 35 |
26% |
| 14Left join + aggregate, the zeros trap |
3 / 35 |
9% |
| 15Anti-join pattern |
0 / 30 |
0% |
| 16CASE WHEN |
0 / 25 |
0% |
| 17Conditional aggregation |
0 / 30 |
0% |
| 18COUNT(DISTINCT) |
0 / 20 |
0% |
| 19Multi-column GROUP BY |
0 / 20 |
0% |
| 20COALESCE |
0 / 15 |
0% |
| 25Date filtering, grouping by month |
0 / 30 |
0% |
| Job-ready total |
145 / 520 |
28% |