Count orders per customer
Build a summary with one row per customer instead of one per order. Join, then group and count real orders, including zero for a customer without orders.
Give each customer an envelope and put their order receipts inside. Count the receipts in each envelope; an empty envelope means zero, although the envelope itself exists.