What is the total number of deaths and damage for all storms with a max speed greater than the average?
CREATE TABLE storm (number_deaths INTEGER, damage_millions_USD INTEGER, max_speed INTEGER)
SELECT SUM(number_deaths), SUM(damage_millions_USD) FROM storm WHERE max_speed > (SELECT AVG(max_speed) FROM storm)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE storm (number_deaths INTEGER, damage_millions_USD INTEGER, max_speed INTEGER) Question: What is the total number of deaths and damage for all storms with a max speed greater than the average? [/INST] SELECT SUM(number_deaths), SUM(damage_millions_USD) FROM storm WHERE max_speed > (SELECT AVG(max_speed) FROM storm) </s>