Binge Watchers
ASKED IN INTERVIEWNetflix
Problem Statement
Netflix content teams want to identify "Binge Watchers" to improve recommendation algorithms. A binge-watching event is defined as a user watching at least 3 different episodes of the same show on the same calendar day.
Write an SQL query to find the names of users and the shows they binged.
Rules:
- A "binge" is 3 or more episodes of the same show_id by the same user_id on the same date.
- Multiple binges by the same user on the same show (on different days) should only result in the user/show pair being listed once.
- Output columns: user_name, show_name.
- Results must be sorted by user_name in ascending order, then show_name in ascending order.
Tests your understanding of
Grouping, Filtering and Date Manipulation
Input Tables
Users
| user_id(INTEGER) | user_name(VARCHAR) |
|---|---|
| 1 | Alice |
| 2 | Bob |
| 3 | Charlie |
| 4 | David |
| 5 | Eve |
| 6 | Frank |
Shows
| show_id(INTEGER) | show_name(VARCHAR) |
|---|---|
| 10 | Stranger Things |
| 11 | The Crown |
| 12 | Black Mirror |
| 13 | Ozark |
| 14 | The Witcher |
| 15 | Cobra Kai |
Watch_Log
| watch_id(INTEGER) | user_id(INTEGER) | show_id(INTEGER) | episode_id(INTEGER) | watch_date(TIMESTAMP) |
|---|---|---|---|---|
| 1 | 1 | 10 | 1 | 2026-02-10 10:00:00 |
| 2 | 1 | 10 | 2 | 2026-02-10 11:00:00 |
| 3 | 1 | 10 | 3 | 2026-02-10 12:00:00 |
| 4 | 2 | 11 | 1 | 2026-02-10 09:00:00 |
| 5 | 2 | 11 | 2 | 2026-02-10 10:00:00 |
| 6 | 3 | 12 | 1 | 2026-02-11 15:00:00 |
| 7 | 3 | 12 | 2 | 2026-02-11 16:00:00 |
| 8 | 3 | 12 | 3 | 2026-02-11 17:00:00 |
Expected Output
| user_name(VARCHAR) | show_name(VARCHAR) |
|---|---|
| Alice | Stranger Things |
| Charlie | Black Mirror |
Tags
MediumASKED IN INTERVIEWGroupingFilteringDate Manipulation
10-15 min
65%