7 cases. Each has its own records. Read them with real SQL.
Start with any case.
- Case 1
BeginnerStart hereThe Midnight Clock
A brass clock goes missing from a railway station's museum room.
Teaches: SELECT * · picking columns · WHERE · COUNT(*) …
9 chaptersStart - Case 2
BeginnerThe Mango Basket
50 mangoes go missing from a housing society's clubhouse before the Mango Party.
Teaches: BETWEEN · COUNT(*) AS · OR · IN (list) …
Needs: SELECT, WHERE, AND
10 chaptersStart - Case 3
Beginner+The Missing Bat
A signed bat disappears from a cricket club during the final.
Teaches: MAX / MIN · GROUP BY · HAVING · IN (subquery) …
Needs: WHERE, AND, ORDER BY, JOIN, COUNT(*)
10 chaptersStart - Case 4
Beginner+The Tech Fair Drone
A prize-winning drone is taken at a tech fair. The visitor list is messy.
Teaches: LIKE with _ · LOWER / UPPER · TRIM · LENGTH …
Needs: WHERE, LIKE, GROUP BY, HAVING, IN
10 chaptersStart - Case 5
IntermediateThe Sweet Box Mystery
A wedding order of sweets arrives 15 boxes short.
Teaches: dates as 'YYYY-MM-DD' · maths in SELECT · SUM · AVG with ROUND …
Needs: JOIN, GROUP BY, HAVING, IN (subquery)
11 chaptersStart - Case 6
Intermediate+The Library Copy
A rare manuscript in a city library is swapped for a copy.
Teaches: table aliases · joining three tables · a subquery that gives one value (> (SELECT AVG …)) · a table joined to itself …
Needs: JOIN, LEFT JOIN, GROUP BY, IN (subquery), dates
11 chaptersStart - Case 7
AdvancedThe Night Train
A laptop disappears from a sleeping coach on an overnight train.
Teaches: time maths with julianday · window functions: RANK · ROW_NUMBER · PARTITION BY …
Needs: JOIN, GROUP BY, subqueries, WITH, dates
12 chaptersStart