Top Spenders Per Client | Dataford Interview Questions

How would you write a query to find the top 3 highest-spending members within each client account using window functions?

Use the provided client account, member, and transaction data. Calculate each member's total transaction amount and use member_id as the deterministic tie-breaker.

Output

One row per qualifying member, with client_account_id, account_name, member_id, member_name, total_spent, and spending_rank
Include only the top three members within each account
Order by client_account_id, then spending_rank

Schema

client_accounts

Column	Type	Description
client_account_idPK	INT	Unique client account identifier
account_name	VARCHAR(100)	Client account name

members

Column	Type	Description
member_idPK	INT	Unique member identifier
client_account_id	INT	Client account associated with the member
member_name	VARCHAR(100)	Member's name

member_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
member_id	INT	Member associated with the transaction
amount	NUMERIC(12,2)	Transaction amount
transaction_date	DATE	Date of the transaction

Your question is Top Spenders Per Client. Start with the requirements and the three 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