Review this SQL that reports revenue per customer.
Each order has multiple payments and each customer has many orders.