00:00

2756. Active Users With Single Device

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

2756. Active Users With Single Device

Medium125 / 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 Manager at Netflix. The product team wants to improve multi-device engagement. Users who have only registered a single active device represent an opportunity for outreach to encourage them to set up additional devices (TV, mobile, tablet).

Find all active users who have exactly one active device registered. Return their user ID, email, and full name. Sort by account creation date (newest first); break ties by user ID ascending.

Schema: users

Column Name	Type
user_id	INTEGER
email	TEXT
full_name	TEXT

Business Problem

Find all active users who have exactly one active device registered. Return their user ID, email, and full name. Sort by account creation date (newest first); break ties by user ID ascending.

Schema: users

Column Name	Type
user_id	INTEGER
email	TEXT
full_name	TEXT

Active Users With Single Device — SQL Medium | 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

device_id	user_id	device_type	os	app_version	registered_at	is_active
1	1	web	Linux	5.8.7	2025-07-26T12:03:07	1
2

device_id	user_id	device_type	os	app_version	registered_at	is_active
1	1	web	Linux	5.8.7	2025-07-26T12:03:07	1
2

user_id	email	full_name
5	omar.wilson@yahoo.com	Omar Wilson
52	asuzuki@gmail.com	Arjun Suzuki
17	michael88@yahoo.com	Michael Ryan
36	anil95@msn.com	Anil Davis
12	pablonakamura@icloud.com	Pablo Nakamura

2756. Active Users With Single Device

Relevant companies

Tags

2756. Active Users With Single Device

Relevant companies

Tags

Sign in to Practice