Roll Up Sunny and Rainy Streaks

Problem

Table: `RainyDays`

```text
+-----------+------+
| Column | Type |
+-----------+------+
| rain_day | date |
+-----------+------+
rain_day is the primary key. Each row is a calendar day on which it rained.
```

Table: `SunnyDays`

```text
+-----------+------+
| Column | Type |
+-----------+------+
| sun_day | date |
+-----------+------+
sun_day is the primary key. Each row is a calendar day that was sunny.
```

Across the year **2023**, every day is either rainy or sunny (never both), and the two tables together cover a set of dates. Collapse consecutive same-weather days into streaks. For each maximal run of consecutive days with the same weather, output one row with the weather and the run's first and last day.

Return `weather` (`'rainy'` or `'sunny'`), `streak_start`, `streak_end`, ordered by `streak_start`. Only consider days in 2023.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns weather, streak_start, streak_end.

Starter code (SQL)

SELECT *
FROM RainyDays;

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