hardHSBC · windowPro
Rank customers by transaction amount, per branch
For each branch, rank customers by transaction amount, highest first. Customers with the same amount should share the same rank.
Return customer, branch, amount, and rnk.
Schema
▸transactions
| id | INT |
| customer | TEXT |
| branch | TEXT |
| amount | NUMERIC |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.