How many accounts does each customer have? List the number and customer id.
CREATE TABLE Accounts (customer_id VARCHAR)
SELECT COUNT(*), customer_id FROM Accounts GROUP BY customer_id
### Context: CREATE TABLE Accounts (customer_id VARCHAR) ### Question: How many accounts does each customer have? List the number and customer id. ### Answer: SELECT COUNT(*), customer_id FROM Accounts GROUP BY customer_id