Query the Murder — Learn SQL by Solving Murder Mysteries
Query the Murder is a free, no-login browser game that teaches SQL by having you query tables of suspects, alibis and events to solve Agatha Christie-inspired murder cases. It has 18 cases that build from basic SELECT and WHERE up to JOINs, GROUP BY, subqueries and window functions.
- The 18 cases are based on Agatha Christie novels such as Murder on the Orient Express and Endless Night, and each one uses a real database you query to check alibis and follow clues.
- Each case asks five SQL questions, and you name the killer by solving the last one.
- It targets beginners, analysts preparing for SQL interviews, and teachers who want a classroom activity without student logins.
Query the Murder is a free browser-based game that teaches SQL through Agatha Christie mysteries. Each of its 18 cases is built on one of her novels, from Murder on the Orient Express to Endless Night, and comes with a working database of suspects, alibis and events. You solve a case by writing queries against those tables: checking whether someone's alibi holds up, tracing a clue, and eventually naming the killer. No account is required, which makes it easy to try on a whim.
The difficulty climbs across the set. The early cases stick to SELECT and WHERE, so they suit someone who has never written a query before. Later cases introduce JOINs, GROUP BY, subqueries and window functions, which are the things that actually trip people up in real work and in interviews. Each case asks five questions, and every question adds a new idea, so you aren't just guessing your way to the answer. You finish when you solve the final question and name the killer.
The obvious audiences are beginners, people brushing up for SQL interviews, and teachers who want a classroom exercise without making students create logins. For a learner, the appeal is that the mystery gives the query a purpose: you're hunting for something, not just practising syntax in the abstract. Worth bookmarking if you want to practise without setting up a database yourself.