CREATE TABLE Accounts (customer_id VARCHAR)

How many accounts does each customer have? List the number and customer id.
SELECT COUNT(*), customer_id FROM Accounts GROUP BY customer_id
SELECT COUNT(*), "customer_id" FROM "Accounts" GROUP BY "customer_id"