Write a solution to find all dates' Id with higher temperatures compared to its previous dates (yesterday).

rising_temp.sql

-- Write your PostgreSQL query statement below
select
id as Id
from
(
    select
    id,
    recordDate,
    temperature,
    LAG(temperature, 1) OVER (
        ORDER BY recordDate asc
    ) as last_date_temp,
    LAG(recordDate, 1) OVER (
        ORDER BY recordDate asc
    ) as last_date
    from Weather
)
where (temperature - last_date_temp) > 0
and (recordDate - last_date) = 1