北京西站在几环_上海公司章程在哪里下载_谷歌推广外包_鸿星尔克网络营销

Write a solution to find all dates’ id with higher temperatures compared to its previous dates (yesterday).

Return the result table in any order.

Input
Weather =

id	recordDate	temperature
1	2015-01-01	10
2	2015-01-02	25
3	2015-01-03	20
4	2015-01-04	30

Output

id
2
4

记住！！不可以写 w.recordDate = y.recordDate+ 1 因为是日期，跨月份会找不出来！
要写 DATEDIFF(w.recordDate, y.recordDate) = 1

My solution:

SELECT w.id
FROM weather wJOIN weather yON DATEDIFF(w.recordDate, y.recordDate) = 1
WHERE w.temperature > y.temperature