Top Spenders Per Region | Dataford Interview Questions

Given a massive table of user transactions, write a query to find the top 3 highest-spending users in each region over the last 30 days.

Use the users and transactions tables. The 30-day window is relative to CURRENT_DATE; exclude users without a region and transactions outside the window.

Output

One row per qualifying user, with region, user_id, user_name, total_spent, and spending_rank.
Include no more than three users per region, ordered by total spending descending, with user_id as the tie-breaker.
Sort the final results by region, then spending_rank.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
region	VARCHAR(50)	User's geographic region

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	User associated with the transaction
transaction_date	DATE	Date on which the transaction occurred
amount	NUMERIC(12,2)	Transaction amount

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