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