Show me all the storms by name.
select name from storm;
List only ones with at least 2 affected 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(*) = 2;
Show all names of the storms except for these.
select name from storm except 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(*) >= 2;