Rising Temperature

Return the ids of days whose temperature is higher than the temperature on the previous calendar day. Order by id.

Table schema

Weather(id INT PRIMARY KEY, record_date DATE, temperature INT)

Sample data

id | record_date | temperature
1 | 2026-01-01 | 10
2 | 2026-01-02 | 25
3 | 2026-01-03 | 20
4 | 2026-01-04 | 30