SQL Window Functions and Challenge | Dataford Interview Questions

Tell me about the SQL window functions you know and how you have used them in the past, and describe a technical challenge you faced at your previous job and how you managed to overcome it.

For the hands-on portion, use the provided player and purchase data to demonstrate a practical ranking analysis.

Output

Return one row per player with player_name, total_spend, and spend_rank.
Include players with no completed purchases, exclude non-completed purchases, and order by rank ascending, then player ID ascending.

Schema

players

Column	Type	Description
player_idPK	INT	Unique player identifier
player_name	VARCHAR(100)	Player display name
region	VARCHAR(30)	Player region

purchases

Column	Type	Description
purchase_idPK	INT	Unique purchase identifier
player_id	INT	Player who made the purchase
amount	NUMERIC(10,2)	Purchase amount
status	VARCHAR(20)	Purchase processing status

Your question is SQL Window Functions and Challenge. 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