0703 til

197. Rising Temperature

-- https://leetcode.com/problems/rising-temperature/

select w.id
from weather w, weather ww
where datediff(w.recordDate ,ww.recordDate )=1 and w.temperature > ww.temperature

join 쓰면 틀림 왜썼지..

select w.id
from weather w, weather ww
where subdate(w.recorddate,1)=ww.recorddate and w.temperature > ww.temperature

subdate(날짜, 숫자) 로 하는 게 더 빠름