STOP WRITING QUERIES ON FAKE CLEAN DATA.
Solving 500 simple queries on a clean, single-table tutorial database will teach you less than solving 30 messy multi-table business problems with missing values, duplicate keys, and performance bottlenecks.
"@here The board meeting is in 12 minutes! The investor deck says our ARR is negative $3.2M because of webhook double-charging and duplicate currency conversions! Exclude refunded transactions with missing dates and fix this query NOW!"
3 TIERS • 100 QUESTIONS EACH • 300 TOTAL
Complete these 300 levels on messy real-world databases and you can crack any SQL technical screen in the world.
Tier 1: The Mud Scrapper (Basic)
Foundations on Dirty Real-World Schemas
Writing SELECT, WHERE, aggregates, GROUP BY, HAVING, and multi-table JOINs on un-sanitized operational data with NULLs, whitespace, and duplicate keys.
- ✓SELECT, WHERE filtering, and logical operators with NULL quirks
- ✓String normalization (TRIM, LOWER, LIKE regex patterns)
- ✓Aggregations: COUNT(DISTINCT) vs COUNT(*), SUM, AVG with COALESCE
- ✓GROUP BY and HAVING on dirty categorical fields
- ✓INNER, LEFT, and RIGHT JOINs avoiding accidental fanouts
- ✓Basic scalar and correlated subqueries in WHERE/FROM clauses
- ⚠User IDs formatted inconsistently (e.g. 'USR-001' vs 'usr_1')
- ⚠Amounts stored as text with stray currency symbols ('$14.50')
- ⚠Null and empty string ambiguity in country/status fields
- ⚠Order items with missing foreign keys due to deleted accounts
EARN YOUR DEDICATED BADGE FOR EACH LEVEL
The Mud Scrapper
Complete all 100 basic messy questions (SELECT, NULLs, dirty JOINs).
The Window Wizard
Complete all 100 intermediate questions (CTEs, DENSE_RANK, LEAD, LAG).
The Schema Exorcist
Complete all 100 advanced nightmare queries (recursive CTEs, sessionization).
SQL Demigod
100% mastery. Guaranteed to crack any SQL interview on Earth.
REAL LEADERBOARD: TOP 300 CHALLENGE SOLVERS
Hall of Fame is Live!
No users have solved levels on this platform deployment yet. Sign up, solve your first dirty challenge, and be the first to claim the #1 spot!
THE SQL GRIT HONOR CODE: HUMAN MUSCLE ONLY
There are no proctors, no browser locks, and no webcam spyware. If you feed these 300 questions to ChatGPT, you will get a green checkmark on our site and then fail your live technical screen in front of an interviewer. Solve them yourself, wrestle with the dirty schemas, and build real muscle.