Top Users by Total Spend Per Region | Dataford Interview Questions

Write a SQL query to find the top 5 users by total spend in each region.

Treat users without transactions as having zero spend. Include each user at most once, and use user_id as the tie-breaker when total spending is equal.

Output

One row per selected user, with region, user_id, user_name, and total_spend
Include up to five users per region, ordered by region, descending total_spend, then ascending user_id

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
amount	NUMERIC(12,2)	Transaction amount

Your question is Top Users by Total Spend 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