Subscribers With Two Streams Within Five Days

Problem

A music app records each listening session. Table `streams` has `(stream_id, listener_id, played_on)` where `stream_id` is unique and `played_on` is a date.

Report the `listener_id` of every listener who has any two streams that occurred at most 5 days apart (the two dates differ by 5 days or fewer).

Return the result ordered by `listener_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns listener_id.

Starter code (SQL)

SELECT *
FROM streams;

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