Leecode SQL 197. Rising Temperature 日期差用 DATEDIFF()

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 =

Output

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

My solution:

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