What is the region id for region name Denmark?
select region_id from region where region_name = 'Denmark'
Show me all storm ids affecting a region id of 12.
select t3.storm_id 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'
What is the name of this storm?
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'