# 197. 上升的温度
# https://leetcode-cn.com/problems/rising-temperature/

# SQL架构
Create table If Not Exists Weather (id int, recordDate date, temperature int);
Truncate table Weather;
insert into Weather (id, recordDate, temperature) values ('1', '2015-01-01', '10');
insert into Weather (id, recordDate, temperature) values ('2', '2015-01-02', '25');
insert into Weather (id, recordDate, temperature) values ('3', '2015-01-03', '20');
insert into Weather (id, recordDate, temperature) values ('4', '2015-01-04', '30');

# Write your MySQL query statement below
select
    w1.id as id
from
    Weather w1
    join Weather w2 on datediff(w1.recordDate, w2.recordDate) = 1
    and w1.temperature > w2.temperature;

# clean-up
drop table Weather;