Can you please show me the average damage for all storms?
select avg ( damage_millions_usd ) from storm
Can you please show me the maximum damage for all storms?
select max ( damage_millions_usd ) from storm
Can you please show me the minimum damage for all storms?
select min ( damage_millions_usd ) from storm
Can you please show me the minimum damage for all storms with maximum speed higher than 1000?
select min ( damage_millions_usd ) from storm where max_speed > 1000
Can you please show me the maximum damage for all storms with maximum speed higher than 1000?
select max ( damage_millions_usd ) from storm where max_speed > 1000