SQL Window Functions Approach | Dataford Interview Questions

Explain your approach to solving a problem using SQL window functions.

Illustrate the approach using the supplied transactions table. Return posted transactions with their rank by amount within each account, handling tied amounts and null amounts explicitly.

Output

One row per posted transaction.
Columns: transaction_id, account_id, transaction_date, amount, and amount_rank.
Rank highest amounts first within each account; tied amounts share a rank and null amounts appear last.
Order by account_id, amount_rank, then transaction_id.

Schema

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
account_id	VARCHAR(20)	Account associated with the transaction
transaction_date	DATE	Date of the transaction
amount	DECIMAL(10,2)	Transaction amount
status	VARCHAR(20)	Processing status of the transaction

Your question is SQL Window Functions Approach. Start with the requirements and the one table 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