Using SQL Window Functions | Dataford Interview Questions

Describe how you would use window functions in SQL.

Use the supplied players and purchases tables to demonstrate the answer. Calculate completed purchase spend for active players and assign ranks, including players with no completed purchases.

Output

One row per active player, with player_name, total_spend, and spend_rank
Ties receive the same rank, with gaps after ties
Sort by total_spend descending, then player_id ascending

Schema

players

Column	Type	Description
player_idPK	INT	Unique player identifier
player_name	VARCHAR(100)	Player display name
is_active	BOOLEAN	Whether the player is currently active

purchases

Column	Type	Description
purchase_idPK	INT	Unique purchase identifier
player_id	INT	Player associated with the purchase
amount	DECIMAL(10,2)	Purchase amount
status	VARCHAR(20)	Purchase state

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