๐Ÿ”ฅNow in early access. Be one of the first detectives

Learn SQL by solving mysteries

Crack cases, write queries, and become a SQL detective. No experience needed.

โœ“ Free to startโœ“ No credit cardโœ“ Minutes to learn
The Process

How It Works

Become a data detective in three steps. No prior experience required.

1
?

Pick an Investigation

Browse Cases by difficulty and SQL topic. Each is self-contained with real data and a mystery to crack.

2

Query the Database

Write SQL in the browser. No setup needed. Get hints from Chief Fox when you get stuck.

3

Crack the Case

Use your results to name the suspect and close the case. Earn XP and level up your rank.

THE JOURNEY

54 cases. Five ranks.
One detective: you.

A complete path from your first WHERE clause to window functions, told as one career on the force. Drills sharpen each skill, exams earn your promotions, and every rank comes with a certificate.

54CASES
12DRILLS
4EXAMS
4CERTIFICATES

Recruit

FIRST CASE

Rookie

SELECT ยท WHERE ยท LOGIC

Detective

AGGREGATES ยท NULLS ยท CAST

Senior

JOINS ยท SUBQUERIES ยท CTES

Chief

WINDOW FUNCTIONS

Concepts when the story needs them

JOINs show up when suspects and alibis stop matching. Nothing is taught in a vacuum.

Exams that mean something

Pass the level exam to earn your promotion and a shareable certificate for each rank.

Streaks and a global leaderboard

Daily streaks, XP rankings, public detective profiles. Friendly pressure included.

INVESTIGATIONS

Then prove it for real

Guided cases teach you. Investigations test you. A full mystery across six tables, three acts, and a ticking clock. When you think you have it, you make one accusation.

  • No hints, no training wheels. Just you, the schema, and the evidence.
  • Real multi-table schemas. Staff records, sensor logs, shipping manifests, phone records.
  • One accusation. Name the perpetrator and their role. Get it wrong, live with it.
THE LOUVRE AFFAIR
โ— ACT 1ACT 2ACT 3
00:15MAKE ACCUSATION
QUESTION 1 OF 6 ยท THE WRONG THEORY

The museum's sensor network flagged an anomaly on the night of November 28th. Which gallery room did it occur in?

Type your answer and press Confirm
TABLES ON FILE
  • staff
  • badge_events
  • sensor_logs
  • artwork_registry
  • shipping_manifests
  • communication_records
THE SANDBOX

Off duty? Query anything.

Seven real datasets, 44 tables, no objectives and no hints. The fastest way to make SQL stick is asking your own questions about data you actually care about.

IMDB Top 250

7 TABLES ยท 4,888 ROWS

Which director has the highest average rating across their films?

Metro Crime

7 TABLES ยท 2,239 ROWS

200 cases of homicide, fraud and theft. Which detective closes the most?

Spotify Wrapped

6 TABLES ยท 11,039 ROWS

A full year of listening history. Which artist gets skipped the most?

Pokemon

8 TABLES ยท 12,015 ROWS

All 1,025 base forms across 9 generations. Which type rules the stat charts?

NBA 2024-25

4 TABLES ยท 794 ROWS

Official season data. Which team has the biggest home-court advantage?

Steam Games

7 TABLES ยท 8,855 ROWS

424 of Steam's most popular games. Do free games really get worse reviews?

54
Cases to Solve
100%
Free to Start
5
Ranks, Rookie to Chief
Zero
Setup. Runs in your browser.

Ready to join the precinct?

Your first case is waiting. Start learning SQL today. It's free and you'll be writing queries in minutes.

Try for free now ยท No credit card required ยท First case in minutes