Database: storm_record
Question: What is the total number of deaths and damage for all storms with a max speed greater than the average?
SQL:
SELECT sum(number_deaths) ,  sum(damage_millions_USD) FROM storm WHERE max_speed  >  (SELECT avg(max_speed) FROM storm)