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

What is the total number of deaths and damage for all storms with a max speed greater than the average?
SELECT SUM(number_deaths), SUM(damage_millions_usd) FROM storm WHERE max_speed > (SELECT AVG(max_speed) FROM storm)
SELECT SUM("number_deaths"), SUM("damage_millions_usd") FROM "storm" WHERE "max_speed" > (SELECT AVG("max_speed") FROM "storm")