The SQL Murder Mystery was created by Joon Park and Cathy He while they were Knight Lab fellows. It's a fun game for experienced SQL users to solve an intriguing crime if, like me, you love puzzles and coding in equal measure! 😅 All the clues to the murder mystery are buried in a database, and you need to use SQL to navigate the vast network of information.
- Take a look through the Solution.md file to see my approach to solving the murder, and the sql code I wrote to do so.
- Have a go yourself! You can find the SQL Murder Mystery in-browser here if you'd like to do the challenge in your browser.
- If you'd like to, you can also go to the GitHub repo here for futher info and instuctions on how to download and run this challenge on your local machine.
Thank you all those involved in creating this fun educational resource:
The SQL Murder Mystery was created by Joon Park and Cathy He while they were Knight Lab fellows. See the GitHub repository here for more information.
Adapted and produced for the web by Joe Germuska.
This mystery was inspired by a crime in the neighboring Terminal City.
Web-based SQL is made possible by SQL.js.
SQL query custom web components created and released to the public domain by Zi Chong Kao, creator of Select Star SQL.
Detective illustration courtesy of Vectors by Vecteezy.
Original code for this project is released under the MIT License.
Original text and other content for this project is released under Creative Commons CC BY-SA 4.0.