select w1.Id
from Weather w1, Weather w2
where w1.Temperature > w2.Temperature and TO_DAYS(w1.Date) = TO_DAYS(w2.Date) + 1
select w1.Id
from Weather w1 inner join Weather w2
where w1.Temperature > w2.Temperature and TO_DAYS(w1.Date) = TO_DAYS(w2.Date) + 1