Stations With a Warming Streak

Problem

Table: `reading_log`

| Column Name | Type |
|---|---|
| reading_id | int |
| station_id | int |
| read_on | date |
| high_celsius | int |

`reading_id` is the primary key. Each row is one station's recorded daily high temperature. A station records at most one reading per day.

Find every station that had a *warming streak*: at least three consecutive calendar days where each day's `high_celsius` was strictly greater than the day before. For each such station, report `station_id`, the streak's first date as `streak_start`, and the streak's last date as `streak_end`. Order by `station_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns station_id, streak_start, streak_end.

Starter code (SQL)

SELECT *
FROM reading_log;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard