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 name of the storm where no people died.
assistant
SELECT name FROM storm WHERE number_deaths = 0 ;
human
How about the number of deaths for the rest of the storms?
assistant
SELECT number_deaths FROM storm WHERE number_deaths > 0 ;
human
List their names and dates active as well.
assistant
SELECT name , dates_active , number_deaths FROM storm WHERE number_deaths >= 1 ;