[LeetCode] 197. Rising Temperature

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH record_list AS (
    SELECT W1.*
        , W2.recordDate AS yesterday
        , W2.temperature AS temperature_yesterday
    FROM Weather AS W1
        LEFT JOIN Weather AS W2 ON W1.recordDate = DATE_ADD(W2.recordDate, INTERVAL 1 DAY)
)

SELECT id AS Id
FROM record_list
WHERE temperature > temperature_yesterday