Lab 2

This assignment is in the style of a 'whodunit' mystery. The police keep their crime data in the sql-murder-mystery schema on sunapee. A detective told you that the crime you must solve 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 database whose schema diagram is:

This assignment is based on https://mystery.knightlab.com/ (honor code: do not look at the solution posted online).

Exercises

1. Follow the clues, starting with the crime scene report table
2. Find the name of the killer
3. When you find the killer, look at their interview and find out who paid for the murder.

Submission Instructions

Submit one .sql file on Canvas with all queries you used to find the killer and who paid that person to commit murder. Provide comments in the SQL so we can determine what you learned about the case from each query. In the submission comments on Canvas list the name of the killer and who paid.