Show all customer ids and the number of accounts for each customer.
select customer_id, count(*) from accounts group by customer_id