List name, dates active, and number of deaths for all storms with at least 1 death.
CREATE TABLE region (
    region_id number,
    region_code text,
    region_name text
)

CREATE TABLE storm (
    storm_id number,
    name text,
    dates_active text,
    max_speed number,
    damage_millions_usd number,
    number_deaths number
)

CREATE TABLE affected_region (
    region_id number,
    storm_id number,
    number_city_affected number
)
SELECT name, dates_active, number_deaths FROM storm WHERE number_deaths >= 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: List name, dates active, and number of deaths for all storms with at least 1 death. ### Input: CREATE TABLE region (
    region_id number,
    region_code text,
    region_name text
)

CREATE TABLE storm (
    storm_id number,
    name text,
    dates_active text,
    max_speed number,
    damage_millions_usd number,
    number_deaths number
)

CREATE TABLE affected_region (
    region_id number,
    storm_id number,
    number_city_affected number
) ### Response: SELECT name, dates_active, number_deaths FROM storm WHERE number_deaths >= 1