Daily Temperature Increase Detector

You are given a table named Weather with daily measurements:

• id: unique row identifier
• recordDate: calendar date for the reading
• temperature: measured value for that date

Return the ids of all days where temperature is strictly higher than the temperature on the previous calendar day.

Important rule:

• Comparison is allowed only if yesterday's date exists in the table.
• If the previous date is missing, that row must not be included.

Output requirements:

• Return exactly one column: id
• Row order can be arbitrary unless your local test setup requires deterministic ordering

This problem should be solvable in both:

• SQL (SQLite 3.27.2)
• Pandas

Weather:
| id | recordDate | temperature |
|----|------------|-------------|
| 1  | 2015-01-01 | 10          |
| 2  | 2015-01-02 | 25          |
| 3  | 2015-01-03 | 20          |
| 4  | 2015-01-04 | 30          |

[
  {"id": 2},
  {"id": 4}
]

Weather:
| id | recordDate | temperature |
|----|------------|-------------|
| 10 | 2024-05-01 | 12          |
| 11 | 2024-05-03 | 18          |
| 12 | 2024-05-04 | 19          |

[
  {"id": 12}
]

Weather:
| id | recordDate | temperature |
|----|------------|-------------|
| 21 | 2023-12-31 | -2          |
| 22 | 2024-01-01 | -2          |
| 23 | 2024-01-02 | 1           |

[
  {"id": 23}
]