Return the names and ids of each account, as well as the number of transactions.
SELECT T2.account_name ,  T1.account_id ,  count(*) FROM Financial_transactions AS T1 JOIN Accounts AS T2 ON T1.account_id  =  T2.account_id GROUP BY T1.account_id
SELECT T2.account_name ,  T1.account_id ,  count(*) FROM Financial_transactions AS T1 JOIN Accounts AS T2 ON T1.account_id  =  T2.account_id GROUP BY T1.account_id
[{'account_name': '390', 'account_id': 4, 'count(*)': 1}, {'account_name': '371', 'account_id': 6, 'count(*)': 3}, {'account_name': '710', 'account_id': 8, 'count(*)': 1}, {'account_name': '337', 'account_id': 9, 'count(*)': 4}, {'account_name': '191', 'account_id': 11, 'count(*)': 1}, {'account_name': '601', 'account_id': 12, 'count(*)': 1}, {'account_name': '272', 'account_id': 13, 'count(*)': 3}, {'account_name': '861', 'account_id': 14, 'count(*)': 1}]