SQL Noir Detective Mystery

Solve cases with SQL: SELECT to joins, while the data tells the story. (About 5 hours)

1.Click a table drawer to see columns, then write SQL in the answer tray.

2.Press Run. One star for the right answer, one for no hints, one for scan budget.

3.New to SQL? Start at Intern. Placement check skips ranks you already know.

Skills this game covers

Skill 1 of 5

Ask a question of the data

Write SELECT, WHERE, ORDER BY, and simple filters.

Skill 2 of 5

Summarize a dataset

Count, group, and filter piles with GROUP BY and HAVING.

Skill 3 of 5

Combine datasets

Join tables and use subqueries to follow a story across data.

Skill 4 of 5

Find trends

Use window functions and CTEs to spot trends over time.

Skill 5 of 5

Answer product questions

Build funnels, retention, and warehouse-scale SQL on a budget.