SELECT customer_id ,  count(*) FROM Accounts GROUP BY customer_id
Show all customer ids and the number of accounts for each customer.
SELECT customer_id , count ( * ) FROM Accounts GROUP BY customer_id
select customer_id , count ( * ) from accounts group by customer_id
Show all customer ids and the number of accounts for each customer .