What are the names of the affected regions?
select region.region_name from region join affected_region on affected_region.region_id = region.region_id;
Show the distinct region names.
select distinct region.region_name from region join affected_region on affected_region.region_id = region.region_id;
How many distinct affected regions are there?
select count(distinct region_id) from affected_region