Show all customer ids and the number of accounts for each customer.
CREATE TABLE Accounts (customer_id VARCHAR)
SELECT customer_id, COUNT(*) FROM Accounts GROUP BY customer_id
### Context: CREATE TABLE Accounts (customer_id VARCHAR) ### Question: Show all customer ids and the number of accounts for each customer. ### Answer: SELECT customer_id, COUNT(*) FROM Accounts GROUP BY customer_id