Create table  weather_forecast (
date date,
temperature decimal,
avg_humidity decimal,
avg_dewpoint decimal, 
avg_barometer decimal,
avg_windspeed decimal,
avg_gutspeed decimal,
avg_direction decimal
, rainfall_month decimal
, rainfall_year decimal
, maxrain_permin decimal
, max_temp decimal
, min_temp decimal
, max_humidity decimal,
min_humidity decimal
, max_pressure decimal
, min_pressure decimal
, max_winspeed decimal
, max_gutspeed decimal
, maxheat_index decimal
, month int
, diff_pressure decimal(7,5) 
);

如果最大阵风速度从每小时55英里增加，我需要获取未来4天的详细资料。我只能做到这一点：

with t1 as(
select max_gutspeed, date
from weather_forecast
where max_gutspeed >55 )
, t2 as (
    select date, row_number() over () as rn
    from weather_forecast)
 select distinct(rn), t1.date, t1.max_gutspeed
from t1
inner join t2 on t1.date = t2.date
order by t2.rn asc`

另外，我如何找到温度下降的最大和最小天数？
我试着用临时表做，但我卡住了，不知道下一步。