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
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
[{'customer_id': 3, 'customer_first_name': 'Joesph', 'customer_last_name': 'Schaefer', 'count(*)': 1}, {'customer_id': 6, 'customer_first_name': 'Vesta', 'customer_last_name': 'Leuschke', 'count(*)': 1}, {'customer_id': 8, 'customer_first_name': 'Meaghan', 'customer_last_name': 'Keeling', 'count(*)': 4}, {'customer_id': 9, 'customer_first_name': 'Abbey', 'customer_last_name': 'Ruecker', 'count(*)': 1}, {'customer_id': 12, 'customer_first_name': 'Jensen', 'customer_last_name': 'Muller', 'count(*)': 1}, {'customer_id': 13, 'customer_first_name': 'Kieran', 'customer_last_name': 'Auer', 'count(*)': 4}, {'customer_id': 15, 'customer_first_name': 'Ruby', 'customer_last_name': 'Boyle', 'count(*)': 3}]