What is 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;
Which storm affected the greatest number of 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 order by count(*) desc limit 1;
Show its max speed in addition to its name.
select t1.name, t1.max_speed from storm as t1 join affected_region as t2 on t1.storm_id = t2.storm_id group by t1.storm_id order by count(*) desc limit 1;