上升的温度
date_add(interval expr type) 使用日期相加函数
select w1.id from Weather w1 left join Weather w2 on w1.recordDate = date_add(w2.recordDate, interval 1 day) where w1.temperature > w2.temperature
以下个人解答日期排序和id不相符则不能通过,部分能通过
select w1.id from Weather w1 left join Weather w2 on w1.id = w2.id + 1 where w2.id is not null and w1.temperature > w2.temperature