image_2022-01-11_16-14-40.png
21.1 KB
#N197. Rising Temperature
problem link
#solution
problem link
#solution
select w1.id from weather w1, weather w2
where datediff(w1.recorddate, w2.recorddate)=1 and
w1.temperature>w2.temperature;