Debugging: Double Counting Revenue

Fix this revenue query that double counts due to unnecessary join cardinality: SELECT c.id, SUM(p.amount) FROM customers c JOIN orders o ON c.id = o.customer_id JOIN payments p ON o.id = p.order_id JOIN order_items i ON o.id = i.order_id GROUP BY c.id;