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
Show id, first name and last name for all customers and the number of accounts.
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
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
Show id , first name and last name for all customers and the number of accounts .