CREATE TABLE Accounts (customer_id VARCHAR)
CREATE TABLE Customers (customer_id VARCHAR)

Show the number of all customers without an account.
SELECT COUNT(*) FROM Customers WHERE NOT customer_id IN (SELECT customer_id FROM Accounts)
SELECT COUNT(*) FROM "Customers" WHERE NOT "customer_id" IN (SELECT "customer_id" FROM "Accounts")