SQL murder

SELECT * FROM crime_scene_report 
WHERE type = 'murder' 
AND city = 'SQL City'
AND date = 20180115

SELECT * FROM person
WHERE name LIKE 'Annabel%' AND address_street_name LIKE '%Franklin%'

16371	Annabel Miller	490173	103	Franklin Ave	318771143

14887	Morty Schapiro	118009	4919	Northwestern Dr	111564949


SELECT * FROM person
WHERE address_street_name LIKE 'Northwestern%' ORDER BY address_number  DESC


SELECT * FROM interview 
JOIN person ON person.id = interview.person_id
WHERE person.name = 'Annabel Miller'

I saw the murder happen, and I recognized the killer from my gym when
 I was working out last week on January the 9th.



SELECT * FROM interview 
JOIN person ON person.id = interview.person_id
WHERE person.name = 'Morty Schapiro'


I heard a gunshot and then saw a man run out. He had a "Get Fit Now Gym" bag.
 The membership number on the bag started with "48Z".
 Only gold members have those bags. The man got into a car with a plate that included "H42W".


SELECT * FROM get_fit_now_member WHERE id LIKE '48Z%' AND membership_status = 'gold'

48Z7A	28819	Joe Germuska	20160305	gold
48Z55	67318	Jeremy Bowers	20160101	gold


SELECT person.name FROM drivers_license
JOIN person ON person.license_id = drivers_license.id
WHERE plate_number LIKE '%H42W%'


Tushar Chandra
Jeremy Bowers
Maxine Whitely

SELECT * FROM interview
JOIN person ON person.id = interview.person_id
WHERE person.name = 'Jeremy Bowers'

Meurtrier trouvé :
I was hired by a woman with a lot of money.
 I don't know her name but I know she's around 5'5" (65") or 5'7" (67").
 She has red hair and she drives a Tesla Model S. 
I know that she attended the SQL Symphony Concert 3 times in December 2017. 

Suite :

SELECT * FROM drivers_license
WHERE car_make = 'Tesla' AND car_model = 'Model S'
AND hair_color = 'red'
AND (65 <= height <= 67) 

202298	68	66	green	red	female	500123	Tesla	Model S
291182	65	66	blue	red	female	08CM64	Tesla	Model S
736081	79	69	brown	red	male	GCAQ6Y	Tesla	Model S
918773	48	65	black	red	female	917UU3	Tesla	Model S


SELECT * FROM facebook_event_checkin
JOIN person ON person.id = facebook_event_checkin.person_id
JOIN drivers_license ON person.license_id = drivers_license.id
WHERE drivers_license.id IN (918773, 202298, 291182, 736081)
AND facebook_event_checkin.event_name LIKE '%SQL%'

personne qui a commandité le meurtre : Miranda Priestly