Top Genres by Region SQL | Dataford Interview Questions

Write a SQL query to identify the top 5 most-watched genres by region over the last quarter.

Use the Prime Video viewing data represented by the provided tables. Define the last quarter relative to the current date, and exclude records with missing regions or genres.

Output

One row per qualifying region and genre, with columns region, genre, total_watch_minutes, and genre_rank.
Return the five highest totals per region, breaking ties alphabetically by genre.
Sort by region, then genre_rank, then genre.

Output details

Treat DATE '2026-07-01' as today's date.
Interpret last quarter as the immediately preceding calendar quarter, including its start and excluding its end.
Preserve qualifying region-genre groups whose total watch minutes is NULL; do not otherwise special-case zero values.

Schema

viewing_events

Column	Type	Description
viewing_idPK	INT	Unique viewing event identifier
title_id	INT	Viewed title identifier
region	VARCHAR(50)	Viewer region
watched_at	TIMESTAMP	Timestamp when viewing occurred
watch_minutes	INT	Minutes watched in the event

titles

Column	Type	Description
title_idPK	INT	Unique title identifier
title_name	VARCHAR(200)	Prime Video title name

title_genres

Column	Type	Description
title_idPK	INT	Title identifier
genre	VARCHAR(100)	Genre assigned to the title

Your question is Top Genres by Region SQL. Start with the requirements and the three tables 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