How many customers don't have an account?
SELECT count(*) FROM Customers WHERE customer_id NOT IN (SELECT customer_id FROM Accounts)
customers don't have an account refers to customers not present in the Accounts table; count of such customers is obtained by COUNT(*) with a subquery excluding customers that have an account.