Count the number of accounts corresponding to each customer id.
SELECT count(*) ,  customer_id FROM Accounts GROUP BY customer_id
number of accounts per customer id refers to COUNT(*) GROUPED BY customer_id;