There's been a Murder in SQL City! The SQL Murder Mystery is a self-directed lesson designed to enhance SQL skills and provide a fun challenge for experienced SQL users to solve an intriguing crime. In this project, a murder has taken place on Jan. 15, 2018, in SQL City, and the detective needs your help to gather information, analyze clues, and draw conclusions to solve the case.
- SQL Workbench
Task: Run a query to retrieve the crime scene report for the murder that occurred on Jan.15, 2018, in SQL City. Gather all available details from the report.
Task: Check the personal details of witnesses involved in the case. Retrieve their names, addresses, and any other relevant information.
Task: Access the recorded interviews of witnesses conducted after the murder. Gather insights into their statements and potential clues.
Task: Investigate the gym database using details obtained from the crime scene report and witness interviews. Look for any gym-related information that might be relevant.
Task: Examine the car details associated with the crime scene. Retrieve information about the vehicles present during the incident.
Task: Identify and collect personal details mentioned in the previous query. This includes names, addresses, and any additional details.
Task: Determine who is identified in the previous query as a member of the gym. Utilize the gym database to confirm their membership status.
Task: Analyze the collected data, including crime scene reports, witness interviews, gym records, and car details. Draw conclusions or hypotheses based on the information available.
Task: Document your findings and any insights gained from the SQL investigation. Summarize the key details that lead you to your conclusions.
Task: Prepare a detailed report for the detective, summarizing the events, suspects, and your conclusions. Present the evidence and rationale behind your findings.
Task: Reflect on the investigative process. What challenges did you encounter, and how did you overcome them? Share your reflections on the case-solving experience.
Click here to redirect to Google drive: Click Here
This project is licensed under the MIT License.