SELECT count(*) ,  customer_id FROM Accounts GROUP BY customer_id
How many accounts does each customer have? List the number and customer id.
SELECT count ( * ) , customer_id FROM Accounts GROUP BY customer_id
select count ( * ) , customer_id from accounts group by customer_id
How many accounts does each customer have ? List the number and customer id .