The finance team wants to classify paid orders using the price ranges maintained in the tiers table.
The orders table contains each order's value (amount_usd) and status. The tiers table defines each pricing band using a lower bound (lo) and an upper bound (hi). A band includes its lower bound but excludes its upper bound: [lo, hi).
Prepare a report showing each paid order and the tier containing its amount. Orders with other statuses do not belong in this report. An amount at a shared boundary must belong to only one tier: for example, 100 belongs to [100, 250), not [0, 100).
Ordering: Sort by order_id in ascending order.