human
Schema:
storm (Storm_ID, Name, Dates_active, Max_speed, Damage_millions_USD, Number_Deaths)
region (Region_id, Region_code, Region_name)
affected_region (Region_id, Storm_ID, Number_city_affected)
Please answer with SQL.
assistant
Sure, I understand.
human
Can you please show me the average damage for all storms?
assistant
SELECT AVG ( damage_millions_USD ) FROM storm;
human
Can you please show me the maximum damage for all storms?
assistant
SELECT MAX( damage_millions_USD ) FROM storm;
human
Can you please show me the minimum damage for all storms?
assistant
SELECT MIN( damage_millions_USD ) FROM storm;
human
Can you please show me the minimum damage for all storms with maximum speed higher than 1000?
assistant
SELECT MIN( damage_millions_USD ) FROM storm WHERE max_speed > 1000;
human
Can you please show me the maximum damage for all storms with maximum speed higher than 1000?
assistant
SELECT MAX( damage_millions_USD ) FROM storm WHERE max_speed > 1000 ;