Top Genres by Demographic | Dataford Interview Questions

Given a table of user streaming sessions, write a query to find the top three most-watched genres per user demographic.

Use the provided users and streaming sessions data. Exclude sessions without a valid user, missing genres, or NULL viewing duration. Break ties alphabetically by genre.

Output

One row per included demographic and genre, with demographic, genre, total_minutes_watched, and genre_rank.
Include no more than three genres per demographic.
Sort by demographic, then genre_rank, then genre.

Schema

users

Column	Type	Description
user_idPK	INT	Unique streaming user identifier
demographic	VARCHAR(50)	User demographic category

streaming_sessions

Column	Type	Description
session_idPK	INT	Unique streaming session identifier
user_id	INT	User associated with the session
genre	VARCHAR(50)	Genre watched during the session
minutes_watched	INT	Number of minutes watched during the session

Your question is Top Genres by Demographic. Start with the requirements and the two 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