[LeetCode] 197. Rising Temperature

내 첫 쿼리 SELECT id FROM (SELECT id ,recorddate ,temperature ,(LAG(temperature) OVER (ORDER BY id)) AS tem2 FROM weather) sub WHERE (temperature-tem2)>0 완성 쿼리 SELECT w.id FROM weather w JOIN weather w1 ON DATEDIFF(w.recordDate,w1.recordDate) = 1 AND w.temperature > w1.temperature 조인 조건 ON에 DATEDIFF 함수 사용 가능

2022.06.09