Show me all the affected regions.
select region.region_name from region join affected_region on affected_region.region_id = region.region_id;
Which storm affected region Cyprus?
select t3.name from affected_region as t1 join region as t2 on t1.region_id = t2.region_id join storm as t3 on t1.storm_id = t3.storm_id where t2.region_name = 'Cyprus';
How about Denmark?
select t3.name from affected_region as t1 join region as t2 on t1.region_id = t2.region_id join storm as t3 on t1.storm_id = t3.storm_id where t2.region_name = 'Denmark';