00:00

2014. Latest Active Subscription per User

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

2014. Latest Active Subscription per User

Medium77 / 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 Customer Success Analyst at Netflix. The team needs to see each member's current subscription state for retention analysis. Your task is to provide the most recent active subscription per member with the start date and whether it auto-renews. Sort by the smallest member identifier; break ties by the smallest subscription identifier.

Schema: subscriptions

Column Name	Type
subscription_id	INTEGER
user_id	INTEGER
plan_id	INTEGER
start_date

Business Problem

Schema: subscriptions

Column Name	Type
subscription_id	INTEGER
user_id	INTEGER
plan_id	INTEGER
start_date

Latest Active Subscription per User — SQL Medium | Let's Data Science | Let's Data Science

user_id	subscription_id	start_date	auto_renew	subscription_rank
2	50	2025-03-18	1	1
3	30	2025-03-01	0	1
4	61	2025-06-20	0	1

user_id	subscription_id	start_date	auto_renew	subscription_rank
2	50	2025-03-18	1	1
3	30	2025-03-01	0	1
4	61	2025-06-20	0	1

2014. Latest Active Subscription per User

Relevant companies

Tags

2014. Latest Active Subscription per User

Relevant companies

Tags

Sign in to Practice