197. rising temperature

drop table Weather if exists Weather;
create table Weather (
	`Id` int (1) primary key auto_increment,
	`Date` date,
	`Temperature` int(3)
);
insert into Weather (`Date`, Temperature) values
  ('2015-01-01', 10),
  ('2015-01-02', 25),
  ('2015-01-03', 20),
  ('2015-01-04', 30);

# Write your MySQL query statement below
select today.Id
from Weather yesterday join Weather today on DATE_ADD(yesterday.Date, INTERVAL 1 DAY) = today.Date
where yesterday.Temperature < today.Temperature;