Understand how LEFT JOIN combined with COUNT and GROUP BY correctly counts related rows including zero matches.
You have a `customers` table and an `orders` table (orders.customer_id references customers.id). You want a list of ALL customers with the number of orders each has placed, including customers with zero orders showing 0. Which query is correct?