Write SQL and Python, run instantly in your browser, and track your progress.
You are a Customer Support Analyst at Netflix. The team needs to review members' most recent viewing sessions to triage playback issues. Your task is to provide, for each member, the most recent session with start time, viewing duration, and quality. Include a rank field that indicates recency. Sort by the smallest member identifier; break ties by the smallest session identifier. Consider any session status.
| Column Name | Type |
|---|---|
| session_id | INTEGER |
| user_id | INTEGER |
| device_id | INTEGER |
You are a Customer Support Analyst at Netflix. The team needs to review members' most recent viewing sessions to triage playback issues. Your task is to provide, for each member, the most recent session with start time, viewing duration, and quality. Include a rank field that indicates recency. Sort by the smallest member identifier; break ties by the smallest session identifier. Consider any session status.
| Column Name | Type |
|---|---|
| session_id | INTEGER |
| user_id | INTEGER |
| device_id | INTEGER |
| title_id |
| title_id |
| INTEGER |
| INTEGER |
| episode_id | INTEGER |
| episode_id | INTEGER |
| started_at | TEXT |
| started_at | TEXT |
| ended_at | TEXT |
| ended_at | TEXT |
| watch_seconds | INTEGER |
| watch_seconds | INTEGER |
| quality | TEXT |
| quality | TEXT |
| status | TEXT |
| status | TEXT |
| session_id | user_id | device_id | title_id | episode_id | started_at | ended_at | watch_seconds | quality | status |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2 | 205 |
| session_id | user_id | device_id | title_id | episode_id | started_at | ended_at | watch_seconds | quality | status |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2 | 205 |
| user_id | session_id | started_at | watch_seconds | quality | session_rank |
|---|---|---|---|---|---|
| 1 | 6 | 2025-07-17T05:48:36 | 5580 | 4k | 1 |
| 2 | 10 | 2025-08-30T18:27:27 | 1680 | sd | 1 |
| 3 | 21 |
| user_id | session_id | started_at | watch_seconds | quality | session_rank |
|---|---|---|---|---|---|
| 1 | 6 | 2025-07-17T05:48:36 | 5580 | 4k | 1 |
| 2 | 10 | 2025-08-30T18:27:27 | 1680 | sd | 1 |
| 3 | 21 |
Showing first 5 of 60 rows. Latest session per user.
Showing first 5 of 60 rows. Latest session per user.
| 2025-06-26T05:44:01 |
| 2025-06-26T05:44:01 |
| 2025-06-26T06:33:55 |
| 2025-06-26T06:33:55 |
| 2700 |
| 2700 |
| hd |
| hd |
| completed |
| completed |
| 2 | 1 | 1 | 139 | 2025-04-04T23:41:32 | 2025-04-04T23:57:22 | 678 | 4k | abandoned |
| 2 | 1 | 1 | 139 | 2025-04-04T23:41:32 | 2025-04-04T23:57:22 | 678 | 4k | abandoned |
| 3 | 1 | 2 | 328 | 2024-12-04T15:21:55 | 2024-12-04T16:07:01 | 2460 | 4k | completed |
| 3 | 1 | 2 | 328 | 2024-12-04T15:21:55 | 2024-12-04T16:07:01 | 2460 | 4k | completed |
| 4 | 1 | 1 | 38 | 2025-02-15T10:35:42 | 2025-02-15T11:40:58 | 3626 | uhd | abandoned |
| 4 | 1 | 1 | 38 | 2025-02-15T10:35:42 | 2025-02-15T11:40:58 | 3626 | uhd | abandoned |
| 5 | 1 | 1 | 5 | 2025-06-15T03:24:01 | 2025-06-15T03:33:03 | 293 | sd | error |
| 5 | 1 | 1 | 5 | 2025-06-15T03:24:01 | 2025-06-15T03:33:03 | 293 | sd | error |
| 2025-07-31T17:43:43 |
| 2025-07-31T17:43:43 |
| 143 |
| 143 |
| sd |
| sd |
| 1 |
| 1 |
| 4 | 34 | 2025-05-22T12:01:00 | 2100 | sd | 1 |
| 4 | 34 | 2025-05-22T12:01:00 | 2100 | sd | 1 |
| 5 | 48 | 2025-06-10T15:17:02 | 131 | hd | 1 |
| 5 | 48 | 2025-06-10T15:17:02 | 131 | hd | 1 |