How many regions were affected by 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