SELECT count(*) FROM Customers WHERE customer_id NOT IN (SELECT customer_id FROM Accounts)
Show the number of all customers without 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 )
Show the number of all customers without an account .