SQL Player Ranking by Spend | Dataford Interview Questions

Electronic Arts wants to identify the highest-spending players in each regional market across EA game purchases. Write a PostgreSQL query that calculates each player's total spend and ranks players independently within their region.

Requirements

Join player and purchase data, retaining players with no purchases.
Treat missing purchase totals as zero and exclude players whose region is unknown.
Return the top three players per region, breaking spend ties by ascending player_id.
Sort the final output by region and rank.

Schema

players

Column	Type	Description
player_idPK	INT	Unique player identifier
player_tag	VARCHAR(50)	EA player handle
region	VARCHAR(30)	Player geographic region

purchases

Column	Type	Description
purchase_idPK	INT	Unique purchase identifier
player_id	INT	Player associated with the purchase
amount	NUMERIC(10,2)	Purchase amount in USD

Your question is SQL Player Ranking by Spend. 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