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