SQL Murder Mystery

Welcome to SQL City. A crime has taken place and the detective needs your help.
Write SQL queries to explore the police database and track down the killer.

Database Disconnected

Case File

A crime has taken place and the detective needs your help. The detective gave you the crime scene report, but you somehow lost it. You vaguely remember that the crime was a murder that occurred sometime on Jan. 15, 2018 and that it took place in SQL City. Start by retrieving the corresponding crime scene report from the police department's database.

Available Tables

Discovered Evidence

  • No evidence discovered yet. Keep querying!

SQL Terminal

Query Results

Waiting for query execution...