What's the average max speed for all storms?
select avg(max_speed) from storm;
What are the number of deaths and damage for all storms with a max speed greater than the average?
select number_deaths, damage_millions_usd from storm where max_speed > (select avg(max_speed) from storm);
How about the total death and total damage?
select sum(number_deaths), sum(damage_millions_usd) from storm where max_speed > (select avg(max_speed) from storm);