human
Schema:
storm (Storm_ID, Name, Dates_active, Max_speed, Damage_millions_USD, Number_Deaths)
region (Region_id, Region_code, Region_name)
affected_region (Region_id, Storm_ID, Number_city_affected)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the number of people killed for each storm.
assistant
SELECT Number_Deaths FROM storm ;
human
What's the name of the one that killed the most people?
assistant
SELECT name FROM storm ORDER BY Number_Deaths DESC LIMIT 1 ;
human
What's the names of the regions affected by this storm?
assistant
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 ORDER BY T3.Number_Deaths DESC LIMIT 1 ;