Top 5 Shows by Region | Dataford Interview Questions

Given a user engagement table, write a query to identify the top 5 most-watched shows by region.

Use all engagement records with valid region and show values. Treat NULL watch minutes as contributing nothing. Return exactly five shows per region, breaking equal totals alphabetically by show name.

Output

One row per ranked show and region
Columns: region, show_name, total_watch_minutes, and region_rank
Include only the top five shows in each region
Sort by region, then region_rank

Schema

user_engagement

Column	Type	Description
engagement_idPK	INT	Unique engagement record identifier
region	VARCHAR(50)	User viewing region
show_name	VARCHAR(100)	Name of the watched show
watch_minutes	INT	Minutes watched in the engagement record

Your question is Top 5 Shows by Region. Start with the requirements and the one table in the Question tab.

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

Problem

Given a user engagement table, write a query to identify the top 5 most-watched shows by region.

Output

One row per ranked show and region
Columns: region, show_name, total_watch_minutes, and region_rank
Include only the top five shows in each region
Sort by region, then region_rank

Schema

user_engagement

Column	Type	Description
engagement_idPK	INT	Unique engagement record identifier
region	VARCHAR(50)	User viewing region
show_name	VARCHAR(100)	Name of the watched show
watch_minutes	INT	Minutes watched in the engagement record

Your question is Top 5 Shows by Region. Start with the requirements and the one table in the Question tab.

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