[LeetCode] Rising Temperature

select q1.id
from weather as q1
left join
(select date_add(recordDate, interval 1 day) as date
           , temperature
from weather) as q2
on q1.recorddate = q2.date
where q2.temperature < q1.temperature

date_add(기준 날짜, interval 숫자 시간단위)를 하면 시간을 더하거나 뺄 수 있다.

 

(문제 출처 - https://leetcode.com/problemset/database/)