How many transaction does each account have? Show the number and account id.
select count(*), account_id from financial_transactions