How many accounts are there for each customer id?
select customer_id, count(*) from accounts group by customer_id