About

SQL Mystery Cases

Every case is based on an Agatha Christie novel with its own database of suspects, alibis and events. Answer 5 questions with SQL to name the killer.

Easy Cases

The basics: SELECT, WHERE, ORDER BY, BETWEEN and LIKE, plus your first GROUP BY

Case 1: Murder on the Orient Express Case 2: The Murder of Roger Ackroyd Case 3: The Mysterious Affair at Styles Case 14: The Murder at the Vicarage Case 15: The A.B.C. Murders Case 16: A Murder is Announced
Medium Cases

Connect tables with JOIN, then group and label suspects with GROUP BY, HAVING and CASE WHEN

Case 4: Murder in Mesopotamia Case 5: Evil Under the Sun Case 6: Crooked House Case 10: Lord Edgware Dies Case 11: Cards on the Table Case 12: The Clocks
Hard Cases

Everything so far plus window functions and WITH queries. Best once joins feel easy

Case 7: And Then There Were None Case 8: Death on the Nile Case 9: Five Little Pigs Case 13: Appointment with Death Case 17: Murder is Easy Case 18: Endless Night