Rank Top 3 Per Department | Dataford Interview Questions

Write a SQL query using window functions to rank transactions within each department by amount and return the top 3 per department.

Ties should receive the same rank, so a department may return more than three rows. Exclude transactions that do not belong to a defined department.

Output

One row per qualifying transaction, with transaction_id, department_name, amount, and amount_rank.
Include rows with an amount rank of 3 or better, ordered by department, rank, amount descending, and transaction ID.

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
department_id	INT	Department associated with the transaction
amount	NUMERIC(12,2)	Transaction amount

Your question is Rank Top 3 Per Department. 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.