Show me the names of all storms that affect more than 1 regions?
select t1.name from storm as t1 join affected_region as t2 on t1.storm_id = t2.storm_id group by t1.storm_id having count(*) > 1;
List the name for storms and 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;