Top N Transactions Per Month | Dataford Interview Questions

Write SQL to find the top N users by transaction amount for each month.

Use N = 2 for the sample evaluation. Include all transactions, associate each transaction with its user, and calculate totals by calendar month.

Output

One row per selected user and month with columns month, user_id, user_name, total_amount, and user_rank.
Include only the top two users within each month, resolving equal totals by ascending user_id.
Order by month ascending, then user_rank ascending.

users

Column	Type	Description
user_idPK	INT	Unique Brigit user identifier
user_name	VARCHAR(100)	Display name of the user

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	User who initiated the transaction
transaction_at	TIMESTAMP	Timestamp when the transaction occurred
amount	NUMERIC(12,2)	Transaction amount

Your question is Top N Transactions Per Month. 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.