Show the id of accounts with a financial transaction.
select account_id from financial_transactions
For each of them, count the number of financial transactions.
select count(*), account_id from financial_transactions group by account_id