Count the number of accounts corresponding to each customer id.
select count(*), customer_id from accounts group by customer_id