00:00

1009. Active Subscribers With Recent UHD/4K Activity

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

1009. Active Subscribers With Recent UHD/4K Activity

Hard10 / 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 analyst for the marketing team at Disney+. The team wants to reward its most engaged subscribers—those who are actively subscribed and consistently watch content in the highest available quality. They plan to send a special 'thank you' gift to this cohort.

Your task is to generate a list of these high-value users. A user qualifies if they have an active subscription and have watched at least one completed session in either 'uhd' or '4k' quality between July and December 2024.

The final report should list each qualifying user's ID, their email, their current subscription status, and the timestamp of their most recent high-quality viewing session in that date range. Sort the list by the most recent session time.

Schema: users

Column Name	Type
user_id

Business Problem

Schema: users

Column Name	Type
user_id

user_id	email	subscription_status	last_started_at
49	ryan48@gmail.com	active	2024-12-29T15:42:12
52	asuzuki@gmail.com	active	2024-12-23T00:05:51
15	emily.muller@aol.com	active	2024-12-19T07:00:13
34	hana.davis@outlook.com	active

user_id	email	subscription_status	last_started_at
49	ryan48@gmail.com	active	2024-12-29T15:42:12
52	asuzuki@gmail.com	active	2024-12-23T00:05:51
15	emily.muller@aol.com	active	2024-12-19T07:00:13
34	hana.davis@outlook.com	active

Active Subscribers With Recent UHD/4K Activity — 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

1009. Active Subscribers With Recent UHD/4K Activity

Relevant companies

Tags

1009. Active Subscribers With Recent UHD/4K Activity

Relevant companies

Tags

Sign in to Practice