0197.sql (134B)
1 SELECT W2.id 2 FROM Weather W1, Weather W2 3 WHERE DATEDIFF(W2.recordDate, W1.recordDate) = 1 AND 4 W1.temperature < W2.temperaturea