How to solve: Find Dates with Rising Temperature?

Question

Accepted Answer

We join `Weather w1` (current day) with `Weather w2` (previous day). In standard SQL, we match `DATEDIFF(w1.recordDate, w2.recordDate) = 1` (or `julianday(w1.recordDate) - julianday(w2.recordDate) = 1` in SQLite) and assert `w1.temperature > w2.temperature`.