99. The NOT IN NULL Trap

You want every customer who has never placed an order. The obvious NOT IN (SELECT customer_id FROM orders) looks right — but orders.customer_id contains a NULL. With a NULL in the list, x NOT IN (..., NULL) can never evaluate to TRUE (it is NULL/unknown for every x), so the query silently returns zero rows. The robust fix is a correlated NOT EXISTS, which uses row-level matching and is immune to the NULL.

Task: return id and name of every customer with no matching order, using a NULL-safe approach. Order by id.

Output columns, in order: id, name.

(Note: the inner orders.customer_id set deliberately contains a NULL — this is exactly the case where NOT IN breaks and NOT EXISTS is required.)