SELECT region_name FROM region WHERE region_id NOT IN (SELECT region_id FROM affected_region)
What are the names of regions that were not affected?
SELECT region_name FROM region WHERE region_id NOT IN ( SELECT region_id FROM affected_region )
select region_name from region where region_id not in ( select region_id from affected_region )
What are the names of regions that were not affected ?