Ghost in the SQL Data, 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.
Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.
Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.
Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.
Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!
