select w1.id from Weather as w1, Weather as w2
where DATEDIFF(w1.recordDate, w2.recordDate) = 1 and w2.Temperature < w1.Temperature;
select w1.id from Weather as w1, Weather as w2
where DATEDIFF(w1.recordDate, w2.recordDate) = 1 and w2.Temperature < w1.Temperature;