What are the the full names and ids for all customers, and how many accounts does each have?
select t1.customer_id, t2.customer_first_name, t2.customer_last_name, count(*) from accounts as t1 join customers as t2 on t1.customer_id = t2.customer_id group by t1.customer_id