What are the names of the regions affected?
select region_name from region where region_id in (select region_id from affected_region);
How many are there?
select count(region_name) from region where region_id in (select region_id from affected_region);
How about the names of regions not affected?
select region_name from region where region_id not in (select region_id from affected_region);