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)
regions that were not affected refers to selecting regions that do not appear in the list of affected regions; NOT IN is used to exclude records that match criteria from another select statement;