Sql murder mistery solution

--SELECT 
--  * 
--FROM 
--  crime_scene_report
--WHERE
--  date = 20180115
--  AND city = 'SQL City'
--  AND type = 'murder'
--Security footage shows that there were 2 witnesses. The first witness 
--lives at the last house on "Northwestern Dr". The second witness, named 
--Annabel, lives somewhere on "Franklin Ave".        

--SELECT
--  *,
--  MAX(address_number)
--FROM
--  person
--where
--  address_street_name = 'Northwestern Dr'
--id	name	license_id	address_number	address_street_name	ssn	MAX(address_number)
--14887	Morty Schapiro	118009	4919	Northwestern Dr	111564949	4919

--SELECT
--  *
--FROM
--  person
--where
--  address_street_name = 'Franklin Ave'
--  AND name like 'Annabel%'
--id	name	license_id	address_number	address_street_name	ssn
--16371	Annabel Miller	490173	103	Franklin Ave	318771143

--SELECT * FROM interview
--WHERE person_id = 14887 OR person_id = 16371
--person_id	transcript
--14887	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".
--16371	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
--  (SELECT
--     *
--   FROM
--     get_fit_now_member
--   WHERE
--     membership_status = 'gold'
--     AND id like '48Z%'
--  ) GOLD
--  JOIN (
--	SELECT * FROM get_fit_now_check_in
--  ) CHECKIN ON GOLD.id = CHECKIN. membership_id
--  JOIN person ON GOLD.name = person.name
--  JOIN (
--	SELECT * FROM drivers_license WHERE plate_number like '%H42W%' AND gender = 'male'
--  ) LICENSE ON person.license_id = LICENSE.id  
--  id	person_id	name	membership_start_date	membership_status	membership_id	check_in_date	check_in_time	check_out_time	id	name	license_id	address_number	address_street_name	ssn	id	age	height	eye_color	hair_color	gender	plate_number	car_make	car_model
--  48Z55	67318	Jeremy Bowers	20160101	gold	48Z55	20180109	1530	1700	67318	Jeremy Bowers	423327	530	Washington Pl, Apt 3A	871539279	423327	30	70	brown	brown	male	0H42W2	Chevrolet	Spark LS
              
--SELECT * FROM interview WHERE person_id = 67318
--person_id	transcript
--67318	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. 	

--SELECT
--  *
--FROM
--(SELECT
--  person_id,
--  event_name,
--  COUNT(person_id) attending
--FROM 
--  facebook_event_checkin
--WHERE 
--  event_name = 'SQL Symphony Concert'
--GROUP BY
--  event_name,
--  person_id
-- ) CONCERT
  
--  JOIN person ON CONCERT.person_id = person.id
--  JOIN drivers_license ON drivers_license.id = person.license_id
-- WHERE
-- CONCERT.attending = 3
-- AND (drivers_license.height = 65
-- OR drivers_license.height = 66)

--person_id	event_name	attending	id	name	license_id	address_number	address_street_name	ssn	id	age	height	eye_color	hair_color	gender	plate_number	car_make	car_model
--99716	SQL Symphony Concert	3	99716	Miranda Priestly	202298	1883	Golden Ave	987756388	202298	68	66	green	red	female	500123	Tesla	Model S
			  
--SELECT * FROM interview WHERE person_id = 99716