By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLe customers (customer_id int)
CREATE tABLE orders(customer_id int)
DELETE FROM customers
WHERE customer_id NOT IN (SELECT customer_id FROM orders)