-- Customers who never placed a completed order.

-- (orders.customer_id is NULL for guest checkouts)

SELECT c.customer_id, c.name

FROM customers c

WHERE c.customer_id NOT IN (

    SELECT o.customer_id

    FROM orders o

    WHERE o.status = 'completed'

);