Rank every order globally (no partition) by amount_usd descending. Show all three ranking-function results side-by-side so the difference on tied values is visible.
For ROW_NUMBER(), break ties on order_id ascending so the ordering is deterministic.
Sort by rn ascending.