Skip to content

Latest commit

 

History

History
48 lines (32 loc) · 944 Bytes

README.md

File metadata and controls

48 lines (32 loc) · 944 Bytes

SQL Murder Mystery Challenge

ERD diagram

Get details from crime scene report table

ERD diagram

output

ERD diagram

Get details of the person leaving in the last house on the street

ERD diagram

output

ERD diagram

Get Annabel details who lives around Franklin Ave

ERD diagram

output

ERD diagram

Get details from the interview table

ERD diagram

output

ERD diagram

output

ERD diagram

Combine details from the 2 interviews

ERD diagram

output

ERD diagram

Get suspects with gold membership

ERD diagram

output

ERD diagram

Join the tables to get the final suspect

ERD diagram

output

ERD diagram