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
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
Return the names and ids of each account , as well as the number of transactions .