SELECT customer_id ,  count(*) FROM Accounts GROUP BY customer_id
How many accounts are there for each customer id?
SELECT customer_id , count ( * ) FROM Accounts GROUP BY customer_id
select customer_id , count ( * ) from accounts group by customer_id
How many accounts are there for each customer id ?