-- Total revenue per customer, shipped orders only. Ana's total looks too high - fix it.
SELECT o.customer, SUM(o.amount) AS total FROM orders o JOIN shipments s ON s.order_id = o.id GROUP BY o.customer;