SQL Murder mystery is a project by Knight Lab team. Which focusses on using SQL Queries to solve a case which involves in finding the killer behind a murder crime. This blog walks through the approach i did in order to find the killer behind this murder. So this is the Schema Diagram of the given tables, which we should use to figure out the killer. get_fit_now_check_in - this table gives information about checkin details of each member of the gym get_fit_now_member - this table contains information about the general details of a member of the gym person - this table contains information about the address details of the person drivers_license - this table contains information about the vehicle used by the person interview - this table contains the information regarding what the person revealed during the interview with the detectives facebook_event_checkin - this table contains information about the events the person attended and uploaded about on facebook crime_scene_report -
A Data Science Blog