What are the names of all storms?
select name from storm
How many regions were affected by the first storm?
select t1.name,count ( * ) from storm as t1 join affected_region as t2 on t1.storm_id = t2.storm_id group by t1.storm_id limit 1
What is the number of affected regions for each storm?
select t1.name, count ( * ) from storm as t1 join affected_region as t2 on t1.storm_id = t2.storm_id group by t1.storm_id