Migration check returns nothing

You check that every legacy order was migrated. The query returns 0 rows, yet you know some orders are missing. The new_orders.legacy_id column contains a few NULLs. What is going on?

SELECT id FROM legacy_orders
WHERE id NOT IN (SELECT legacy_id FROM new_orders);