LeetCode #197 上升的温度

https://leetcode-cn.com/problems/rising-temperature/description/

inner join 连接

to_days(DATE) 将日期类型转换为公元0年0月0天到DATE的总天数

select w1.Id from Weather w1 
inner join Weather w2 
on w1.Temperature > w2.Temperature 
and to_days(w1.RecordDate) - to_days(w2.RecordDate) = 1;