from Weather W1, Weather W2
where W2.Temperature > W1.Temperature
I'd say because you use
DATEDIFF the wrong way. Do
DATEDIFF(W2.Date,W1.Date) instead. Or alternatively, compare to
-1 instead of
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.