SQL Murder Mystery

Link: https://mystery.knightlab.com/

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. 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.

NOTE:

• Read SQL Murder Mystery (Info).docx for detailed project info
• Check solution.sql query file for detailed project solution
• Check tasks_results.xlsx for each task query output results
• _sql_murder_mystery.db and sql_murder_mystery.sql file attached

My Investigation Report:

On Jan.15, 2018 a murder was commited in SQL City. When security footage was checked by police, they found that there were 2 witnesses named Annabel Miller from Franklin Ave and Morty Schapiro from last house from Northwestern Dr. When police interviewed them, Morty Schapiro told them that he heard the gunfire sounds and saw a man run out with 'Get Fit Now Gym' bag with membership number on the bag started with '48Z' those kind of bag only possesed ny gold members of gym and saw that the man got into a car with a plate that included 'H42W'. Annabel Miller was presented on the crime scene, he saw the murder happen and he recognizes the killer from his gym when he was working out last week on January the 9th. When police gathered the information from gym on 9th Jan 2018 there were 2 suspects that were presented at that time. And there were 3 suspects from the plate number including 'H42W' when police checked the personal information of all 3 from the license number there was one name which was common from the gym. It was 'Jeremy Bowers' and everything matched perfectly and thus police resolved this murder mystery.

Jeremy Bowers is found guilty based on following evidences:

1. He is a gym member with gold membership
2. He owns a gym bag 48Z55
3. He have a car Chevrolet-Spark LS with plate number 0H42W2
4. He was presented in gym on 9th of January, 2018
5. He was witnessed by Annabel Miller when he was commiting murder
6. Another witness Morty Schapiro saw plate no. while he flew in his car from the incident