SELECT count(*) ,  customer_id FROM Accounts GROUP BY customer_id
Count the number of accounts corresponding to each customer id.
SELECT count ( * ) , customer_id FROM Accounts GROUP BY customer_id
select count ( * ) , customer_id from accounts group by customer_id
Count the number of accounts corresponding to each customer id .