SQL Murder Mystery

SQL_Murder_Mystery.sql

-- https://mystery.knightlab.com/

--select * from get_fit_now_check_in where membership_id like '%48Z%' and check_in_date like '%0109'
--select * from get_fit_now_member where person_id = 16371

/*
select * from person p left join 
drivers_license dl on dl.id = p.license_id left join
interview i on i.person_id = p.id left join
income on income.ssn = p.ssn
where dl.plate_number like '%H42W%'
*/


/*
select * from person p left join 
drivers_license dl on dl.id = p.license_id left join
interview i on i.person_id = p.id left join
income on income.ssn = p.ssn left join
facebook_event_checkin f on f.person_id = p.id
where dl.hair_color = 'red' and car_make = 'Tesla' and car_model = 'Model S'
and dl.gender = 'female' and f.event_name = 'SQL Symphony Concert'
*/

--select * from get_fit_now_check_in where check_in_date like '%0109'
--select * from interview where transcript like '%gym%'
--select * from interview where transcript like '%i saw%' and person_id = 16371
--select * from crime_scene_report where description like '%kill%' and type = 'murder'