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


Runtime: 343 ms, faster than 87.22% of MySQL online submissions for Rising Temperature.

Memory Usage: 0B, less than 100.00% of MySQL online submissions for Rising Temperature.


```sql
# Write your MySQL query statement below

#7:54
SELECT weather2.id FROM Weather AS weather1
INNER JOIN Weather AS weather2
WHERE weather1.temperature < weather2.temperature AND DATE_SUB(weather2.recordDate, INTERVAL 1 DAY) = weather1.recordDate;  
#7:59
```