User Watch Percentage by Show | Dataford Interview Questions

Your question is User Watch Percentage by Show. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Paramount+ wants to measure the reach of a specific show across its registered users. Write a PostgreSQL query that calculates the percentage of all users who watched Star Trek: Strange New Worlds at least once.

Requirements

Count each qualifying user only once, even if they watched the show multiple times.
Use all rows in users as the denominator, including users with no views.
Return one row containing the number of unique viewers, total users, and viewer percentage rounded to two decimal places.
Treat only exact matches to the specified show title as qualifying views.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Paramount+ user identifier
email	VARCHAR(255)	User email address
subscription_tier	VARCHAR(20)	Current subscription plan

views

Column	Type	Description
view_idPK	INT	Unique viewing event identifier
user_id	INT	User associated with the viewing event
show_title	VARCHAR(150)	Title of the show watched
viewed_at	TIMESTAMP	Timestamp when the view occurred