There's been a Murder in SQL City! The SQL Murder Mystery is designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime.
You can try this challenge yourself here.
The code in this repository is one of the possible solution codes to solve the challenge.