Show me the storm ids for each region.
select t2.storm_id from region as t1 join affected_region as t2 on t1.region_id = t2.region_id group by t1.region_id;
What's the maximum number of storms of one region?
select count(t2.storm_id) from region as t1 join affected_region as t2 on t1.region_id = t2.region_id group by t1.region_id order by count(storm_id) desc limit 1;
Show the region names and the number of storms for each region.
select t1.region_name, count(*) from region as t1 join affected_region as t2 on t1.region_id = t2.region_id group by t1.region_id;