News for hackers. Stuff that matters.
Re:SQL Murder Mystery by sqldevuser on Monday December 16, 2019 @01:53PM (#21805851)
Here is a single query to get you both solutions. https://pastebin.com/P7LN9jMz

This was after I solved it the old fashioned way though :)

Re:SQL Murder Mystery by ticmasta on Monday December 16, 2019 @03:48PM (#21807055)
I thought you had created a single massive join to find the answer and was pre-impressed. This is fine in the strict "correct solution" answer but totally against the spirit, so boo!