select w1.Id from Weather w1, Weather w2
where w1.Temperature > w2.Temperature
and datediff(w1.Date, w2.Date) = 1;
Why it doesn't work if I change datediff(w1.Date, w2.Date) = 1 to w1.Id - w2.Id = 1?
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.