- code
select w1.id as 'Id' from Weather w1 join Weather w2 on DATEDIFF(dd, w2.recordDate, w1.recordDate) = 1 where w1.temperature > w2.temperature
select w1.id as 'Id' from Weather w1 join Weather w2 on DATEDIFF(dd, w2.recordDate, w1.recordDate) = 1 where w1.temperature > w2.temperature