Show me the regions affected by a storm with a damage of more than 10 million dollars?
select t2.region_name from affected_region as t1 join region as t2 on t1.region_id = t2.region_id join storm as t3 on t1.storm_id = t3.storm_id where t3.damage_millions_usd > 10;
How about those with affected by storms with no more than 10 deaths?
select t2.region_name from affected_region as t1 join region as t2 on t1.region_id = t2.region_id join storm as t3 on t1.storm_id = t3.storm_id where t3.number_deaths <= 10;
List the region names affected by the storm with a number of deaths of least 10.
select t2.region_name from affected_region as t1 join region as t2 on t1.region_id = t2.region_id join storm as t3 on t1.storm_id = t3.storm_id where t3.number_deaths >= 10;