CREATE TABLE affected_region (region_id NUMBER, storm_id NUMBER, number_city_affected NUMBER)
CREATE TABLE region (region_id NUMBER, region_code CLOB, region_name CLOB)
CREATE TABLE storm (storm_id NUMBER, name CLOB, dates_active CLOB, max_speed NUMBER, damage_millions_usd NUMBER, number_deaths NUMBER)

What are the names, dates active, and number of deaths for storms that had 1 or more death?
SELECT name, dates_active, number_deaths FROM storm WHERE number_deaths >= 1
SELECT "name", "dates_active", "number_deaths" FROM "storm" WHERE "number_deaths" >= 1