How many accounts does each customer have? List the number and customer id.
SELECT count(*) ,  customer_id FROM Accounts GROUP BY customer_id
number of accounts each customer has refers to COUNT(*); listing the number along with customer id refers to including customer_id in the SELECT statement and grouping the results by customer_id;