select * from
(select *,row_number() over (partition by starttime order by air_temperature) as num from weather_forecast desc) t
where t.num=1;
select * from
(select *,row_number() over (distribute by starttime sort by air_temperature) as num from weather_forecast desc) t
where t.num=1;