The Volume Leaderboard

The private-banking desk at Northline Bank keeps a leaderboard of customers by how much money they push through the bank in either direction, and puts a position number beside each name. The desk's rule is that two customers moving identical amounts must show the same position — and the position after a shared one is skipped, so a board can read 1, 2, 2, 4.

transactions — one row per movement of money. customer_id points at a row in customers; type is one of deposit, withdrawal or transfer; txn_date is the day it settled. The ledger is signed: money arriving in an account is stored as a positive amount, and money leaving it as a negative one, so a 600-dollar withdrawal is recorded as -600.

customers — one row per account holder at Northline. account_type is either checking or savings; city is the branch city the account belongs to.

Both tables already exist in the database — there is nothing to create or load.

Task: Write a query that returns three columns — name, volume and volume_rank — one row per customer with at least one movement. volume is the total money they moved ignoring direction, rounded to 2 decimal places; volume_rank is 1 for the largest volume, with customers on identical volumes sharing a position and the next position skipped. Return the rows lowest volume_rank first, with customers sharing a position separated alphabetically by name.

Example output — shape only, on invented customers. Two of them moved the same money, so they share position 3 and position 4 goes unused: