197.上升的温度 https://leetcode.cn/problems/rising-temperature/description/ 分析: subdate()函数,日期-1两个表自连接 select b.id as 'id' from Weather a,Weather b where a.recorddate=subdate(b.recorddate,1) and b.temperature>a.temperature