SQL Window Functions for Top Games | Dataford Interview Questions

Write an SQL query using window functions to find the top three most popular games purchased in each geographic region per month.

Use the provided PlayStation Network purchase and game tables. Exclude purchases without a geographic region or matching game.

Output

One row per qualifying game, region, and month.
Columns: region, purchase_month, game_name, purchase_count, and popularity_rank.
Return at most three games per region and month, ordered by month, region, rank, purchase count descending, and game name ascending. Break ties alphabetically by game name.

purchases

Column	Type	Description
purchase_idPK	INT	Unique purchase identifier
game_id	INT	Purchased game identifier
region	VARCHAR(50)	Geographic region associated with the purchase
purchased_at	TIMESTAMP	Timestamp when the game was purchased

games

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

Your question is SQL Window Functions for Top Games. 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.