00:00

2757. Latest qualifying session per device for active subscribers

HardSQLITE126 / 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

2757. Latest qualifying session per device for active subscribers

Hard126 / 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

As a Senior Data Analyst at Netflix, you're working with the Product Analytics team to understand viewing patterns and device engagement for active subscribers. The team is building a dashboard to monitor user engagement quality by tracking meaningful viewing sessions across different device types.

Your task is to identify the most recent high-quality viewing session for each device used by customers with active subscriptions. A "high-quality" session is defined as a completed session where the user watched at least 10 minutes (600 seconds) of content, indicating genuine engagement rather than accidental starts or brief sampling.

For each qualifying device, you need to find the most recent session that meets the engagement threshold and provide the session ID, customer ID, device ID, when the session started, and how many seconds were watched.

Schema: users

Column Name	Type
user_id	INTEGER
email

Business Problem

Schema: users

Column Name	Type
user_id	INTEGER
email

Latest qualifying session per device for active subscribers — SQL Hard | Let's Data Science | Let's Data Science

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

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

Column Name	Type
subscription_id	INTEGER
user_id	INTEGER
plan_id	INTEGER
start_date	TEXT
end_date	TEXT
status	TEXT

Column Name	Type
subscription_id	INTEGER
user_id	INTEGER
plan_id	INTEGER
start_date	TEXT
end_date	TEXT
status	TEXT

subscription_id	user_id	plan_id	start_date	end_date	status	auto_renew
1	58	6	2025-07-26		active	1
2

Column Name	Type
session_id	INTEGER
user_id	INTEGER
device_id	INTEGER
title_id	INTEGER
episode_id	INTEGER
started_at	TEXT

session_id	user_id	device_id	started_at	watch_seconds
10	2	4	2025-08-30T18:27:27	1680
409	49	94	2025-08-29T00:04:37	1620
104	12	26	2025-08-27T07:49:40	2220

2757. Latest qualifying session per device for active subscribers

Relevant companies

Tags

2757. Latest qualifying session per device for active subscribers

Relevant companies

Tags

Sign in to Practice