SOLUTION

[Bart35]

/select from crime_scene_report where city = 'SQL City' and type = 'murder'/ /select from person where address_street_name = 'Franklin Ave'/ /select from interview where person_id = 14887 / /select from interview where person_id = 16371/ /select from get_fit_now_check_in where membership_id like '48Z%'/ /select from drivers_license where plate_number like '%H42W%' and gender = 'male' / /select from person where license_id = 423327 or license_id = 664760 / /select id from get_fit_now_member where person_id = 51739 or person_id = 67318 / /select from get_fit_now_member where id = '48Z55'/

[Bart35]

20180215 murder REDACTED REDACTED REDACTED SQL City 20180215 murder Someone killed the guard! He took an arrow to the knee! SQL City

20180115 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". SQL City

first witness 14887 Morty Schapiro 118009 4919 Northwestern Dr 111564949

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".

second witness 16371 Annabel Miller 490173 103 Franklin Ave 318771143

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.

Membership membership_id check_in_date check_in_time check_out_time 48Z38 20170611 813 1122 48Z38 20171212 1150 1153 48Z38 20170820 919 921 48Z38 20180314 315 1150 48Z38 20170120 482 1138 48Z7A 20180109 1600 1730 48Z55 20180109 1530 1700

License id age height eye_color hair_color gender plate_number car_make car_model 423327 30 70 brown brown male 0H42W2 Chevrolet Spark LS 664760 21 71 black black male 4H42WR Nissan Altima

suspects id name license_id address_number address_street_name ssn 51739 Tushar Chandra 664760 312 Phi St 137882671 67318 Jeremy Bowers 423327 530 Washington Pl, Apt 3A 871539279

suspect id person_id name membership_start_date membership_status 48Z55 67318 Jeremy Bowers 20160101 gold

murderer Jeremy Bowers

[Bart35]

Better solution:

/select from crime_scene_report where city = 'SQL City' and type = 'murder'/ /select from person where address_street_name = 'Franklin Ave' and name like 'Annabel%'/ /select from interview where person_id = 14887 or person_id = 16371/ /select from get_fit_now_check_in where membership_id like '48Z%'/ /select from drivers_license where plate_number like '%H42W%' and gender = 'male' / /select from person where license_id = 423327 or license_id = 664760/ /select id from get_fit_now_member where person_id = 51739 or person_id = 67318 / /select from get_fit_now_member where id = '48Z55'*/