The finance team wants to view payment records alongside the original amounts of their associated orders.
The payments table records individual payment attempts, while the orders table contains order details.
Prepare a payment-level report showing each payment associated with an existing order, the order's amount_usd, and the payment's status.
An order may have multiple payments, and each payment must appear separately. The amount should reflect the original order value, not the amount of an individual payment.
Ordering: Sort by payment_id in ascending order.