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