197. Rising Temperature mysql

https://leetcode.com/problems/rising-temperature/?envType=study-plan&id=sql-i 

Rising Temperature - LeetCode

 

lag, lead 이런거 찾아보고 있었는데 self join의 on으로 처리해서 풀 수 있었다..

어렵네..

 

select A.id as id from weather a inner join weather b on datediff(a.recordDate, b.recordDate) = 1 and a.temperature > b.temperature;