Top Games Per Region | Dataford Interview Questions

Write a SQL query using window functions to identify the top three most-played games per region.

Use total play minutes as the measure of play activity. Include only games with recorded sessions, return up to three games per region, and break ties alphabetically by game name.

Output

One row per selected region and game, with region_name, game_name, total_play_minutes, and play_rank.
Include ranks 1 through 3 where available.
Order by region_name, then play_rank.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique region identifier
region_name	VARCHAR(100)	Display name of the PlayStation Global region

games

Column	Type	Description
game_idPK	INT	Unique game identifier
game_name	VARCHAR(150)	Game title

play_sessions

Column	Type	Description
session_idPK	INT	Unique play session identifier
region_id	INT	Region associated with the session
game_id	INT	Game played during the session
minutes_played	INT	Minutes played during the session

Your question is Top Games Per Region. 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