Jonarzz

select * from crime_scene_report
where date = '20180115'
and city = 'SQL City'
and type = 'murder';

select id, name
from person
where address_street_name = 'Northwestern Dr'
group by address_street_name
having max(address_number);