00:00

2509. Completed Playback Sessions (Normalized)

MediumSQLITE107 / 1584

Relevant companies

Netflix

Spotify

YouTube

Disney+

Max

Apple TV+

Paramount+

Peacock

Amazon Prime Video

Twitch

SiriusXM

Tidal

Deezer

iHeartMedia

Audible

Crunchyroll

DAZN

FuboTV

Philo

Parrot Analytics

2509. Completed Playback Sessions (Normalized)

Medium107 / 1584

Relevant companies

Netflix

Spotify

YouTube

Disney+

Max

Apple TV+

Paramount+

Peacock

Amazon Prime Video

Twitch

SiriusXM

Tidal

Deezer

iHeartMedia

Audible

Crunchyroll

DAZN

FuboTV

Philo

Parrot Analytics

Sign in to Practice

Write SQL and Python, run instantly in your browser, and track your progress.

Runs live in your browser — no setup
Save progress across all 1,500+ problems
Submit and validate your answer instantly

Business Problem

You are a Data Scientist at Netflix. To better understand user engagement, you are conducting a study on the viewing habits of active users over the last six months. Your focus is on successfully completed viewing sessions.

Your task is to create a clean dataset for this analysis by joining playback_sessions with users. The dataset must only include sessions from active users that were completed, had a positive watch duration, and occurred within the last 180 days.

The final output should include the session and user IDs, the user's country (in uppercase), the total watch time converted to whole minutes, and the session's start date.

Schema: playback_sessions

Column Name	Type

Business Problem

The final output should include the session and user IDs, the user's country (in uppercase), the total watch time converted to whole minutes, and the session's start date.

Schema: playback_sessions

Column Name	Type

users.account_status

Completed Playback Sessions (Normalized) — SQL Medium | Let's Data Science | Let's Data Science

session_id	INTEGER
user_id	INTEGER
device_id	INTEGER
title_id	INTEGER
episode_id	INTEGER
started_at	TEXT
ended_at	TEXT
watch_seconds	INTEGER
quality	TEXT

session_id	INTEGER
user_id	INTEGER
device_id	INTEGER
title_id	INTEGER
episode_id	INTEGER
started_at	TEXT
ended_at	TEXT
watch_seconds	INTEGER
quality	TEXT

Column Name	Type
user_id	INTEGER
email	TEXT
full_name	TEXT
country	TEXT
language	TEXT
created_at	TEXT

Column Name	Type
user_id	INTEGER
email	TEXT
full_name	TEXT
country	TEXT
language	TEXT
created_at	TEXT

user_id	email	full_name	country	language	created_at	account_status
1	andrewbrown@icloud.com	Andrew Brown	CA	en	2025-06-14	active
2

session_id	user_id	country_upper	watch_minutes	start_date
10	2	US	28	2025-08-30
337	40	GB	50	2025-08-30
487	59	FR	33	2025-08-30

session_id	user_id	country_upper	watch_minutes	start_date
10	2	US	28	2025-08-30
337	40	GB	50	2025-08-30
487	59	FR	33	2025-08-30

2509. Completed Playback Sessions (Normalized)

Relevant companies

Tags

2509. Completed Playback Sessions (Normalized)

Relevant companies

Tags

Sign in to Practice