[SQL]rising-temperature

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

LeetCode - The World's Leading Online Programming Learning Platform

with base as (
select
    id, recordDate, temperature 
    , lag(recordDate, 1) over (order by recordDate) last_d
    , lag(temperature, 1) over (order by recordDate) last_t
from weather
)
select
    distinct id
from base
where datediff(recordDate, last_d) = 1 and last_t < temperature