SQL MURDER MYSTERY

There's been a murder in SQL City! This challenge was put together by KnightLab. Using your brilliant SQL skills, you get to solve a murder case and get justice.

SOLVE AWAY!