My solution to the SQL Murder Mystery challenge by Knight Lab.
I started by identifying the relevant report in the crime_scene_report table. The description provided additional information that I could use to narrow down the investigation.
I used these clues to identify both witnesses in the person table.
The interview transcripts from the two witnesses provided enough information to identify the killer using the get_fit_now_member table.
But there was more to the story. The killer's interview transcript revealed that he had been hired by someone else. The information he provided helped narrow down the suspect, although one misleading description initially led me to a dead end.
By following the remaining clues and cross-referencing the available data, I was eventually able to narrow down and identify the person who hired the killer.