W3School TIY Editor

SELECT customers.customer_name, COUNT(orders.order_id) FROM orders LEFT JOIN customers ON orders.customer_id = customers.customer_id GROUP BY customer_name;