Show the account name, id and the number of transactions for each account.
create table financial_transactions (account_id varchar, PRIMARY KEY (account_id)); create table accounts (account_name varchar, account_id varchar, PRIMARY KEY (account_name))
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