Show the account id and the number of transactions for each account
select account_id, count(*) from financial_transactions group by account_id