Loading…
Loading…
Ghost in the SQL Data −10% A call reported a school fire 14 minutes before the first witness saw it. Find out who made it, in SQL, by exploring a year of Paris emergency calls.
Achievements
381 hidden until unlocked
Average Unlock Rate
31%of owners, per achievement
Rare (Under 5%)
924% of the list
Rarest
0.2%Read in Ten Homes
Most Common
97%Taught Once
By Rarity| Unlocked by | Achievements | Share |
|---|---|---|
| Under 1% | 4 | |
| 1–5% | 5 | |
| 5–20% | 10 | |
| 20–50% | 8 | |
| 50% and over | 11 |
All Achievements| # | Achievement | Unlocked |
|---|---|---|
| 1 |  Taught OnceFinish the tutorial. | 97% |
| 2 | The First FilterRun a query with WHERE that comes back with rows. | 93% |
| 3 | The Ashgrove FireClose the Ashgrove fire case. | 89% |
| 4 | Two TablesRun a query with JOIN that comes back with rows. | 79% |
| 5 | Near "Everything"Get your first syntax error. | 79% |
Share of the game’s Steam owners who unlocked each achievement, checked 1 Nov 2026. Steam counts owners who never played, so rates run low. How we count
| 6 | Nothing To ReportRun a query that comes back with no rows. | 78% |
| 7 | The SwitchboardClose the switchboard case. | 74% |
| 8 | In OrderRun a query with ORDER BY that comes back with rows. | 69% |
| 9 | The LodgeClose the lodge case. | 63% |
| 10 | Metropolitan Crime UnitClose every case of the crime unit. | 63% |
| 11 | Nobody Saw ThatReveal a hint. | 58% |
| 12 | The Blue HousesClose the blue houses case. | 47% |
| 13 | Straight ThroughClose a case with no hint and no failed checkpoint. | 44% |
| 14 | The Hospital StalkerClose the hospital stalker case. | 28% |
| 15 | A Hundred QuestionsRun 100 queries. | 26% |
| 16 | The Next BankClose the next bank case. | 22% |
| 17 | A Short ListRun a query with IN that comes back with rows. | 22% |
| 18 | Note to SelfLeave a comment in a query. | 20% |
| 19 | One Row Per GroupRun a query with GROUP BY that comes back with rows. | 20% |
| 20 | One of EachRun a query with DISTINCT that comes back with rows. | 19% |
| 21 | The Orsay CrownClose the Orsay crown case. | 15% |
| 22 | Roughly RightRun a query with LIKE that comes back with rows. | 15% |
| 23 | Ten StrangersClose the ten strangers case. | 12% |
| 24 | A Query Inside a QueryRun a query holding another query that comes back with rows. | 12% |
| 25 | Elixir VFind the 3 flowers of Elixir V. | 9% |
| 26 | After the CountRun a query with HAVING that comes back with rows. | 8% |
| 27 | Letters From La SanteRead the crew's 7 meetings with K. | 7% |
| 28 | Someone Else's CaseClose a case from the community. | 6% |
| 29 | What It Adds Up ToRun a query with SUM that comes back with rows. | 5% |
| 30 | Who Is K?Name K, and who pays him. | 4% |
| 31 | ClosedClose every case. | 4% |
| 32 | The Scratch TableRun a query with WITH that comes back with rows. | 3% |
| 33 | Not Your TableTry to change the data. The desk says no. | 3% |
| 34 | DROP TABLEHidden | 2% |
| 35 | Five Strangers' FilesClose 5 different cases from the community. | 0.5% |
| 36 | Off the PressPublish your first case on the Workshop. | 0.4% |
| 37 | The Readers' ColumnClose 10 different cases from the community. | 0.2% |
| 38 | Read in Ten HomesHave 10 players subscribe to one of your cases. | 0.2% |
