SELECT c.id,c.name,COUNT(o.id) AS paid_orders,COALESCE(SUM(o.total_cents-o.refund_cents),0) AS net_cents FROM customers c LEFT JOIN orders o ON o.customer_id=c.id AND o.status='paid' AND o.order_date>='2026-09-01' AND o.order_date<'2026-10-01' GROUP BY c.id,c.name ORDER BY c.id;