SELECT count(*) FROM Customers WHERE customer_id NOT IN (SELECT customer_id FROM Accounts)
How many customers do not have an account?
SELECT count ( * ) FROM Customers WHERE customer_id NOT IN ( SELECT customer_id FROM Accounts )
select count ( * ) from customers where customer_id not in ( select customer_id from accounts )
How many customers do not have an account ?