Hi can you tell me the name of the regions not affected by storms?
select region_name from region where region_id not in ( select region_id from affected_region )
Can you tell me the names of the cities affected by storm?
select region_name from region where region_id in ( select region_id from affected_region )