Streaming Subscribers on a Hot Streak

Problem

A music app records the days on which each subscriber opened the app.

Table: `Subscribers`

```text
+--------+---------+
| Column | Type |
+--------+---------+
| sub_id | int |
| handle | varchar |
+--------+---------+
sub_id is the primary key. handle is the subscriber's display name.
```

Table: `Opens`

```text
+----------+---------+
| Column | Type |
+----------+---------+
| sub_id | int |
| open_day | date |
+----------+---------+
This table may contain duplicate rows (a subscriber can open the app many times on the same day).
```

A subscriber is on a hot streak if they opened the app on five or more consecutive calendar days. Report the `sub_id` and `handle` of every such subscriber, ordered by `sub_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns sub_id, handle.

Starter code (SQL)

SELECT *
FROM Subscribers;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium