SELECT account_id ,  count(*) FROM Financial_transactions GROUP BY account_id
What are the different account ids that have made financial transactions, as well as how many transactions correspond to each?
SELECT account_id , count ( * ) FROM Financial_transactions GROUP BY account_id
select account_id , count ( * ) from financial_transactions group by account_id
What are the different account ids that have made financial transactions , as well as how many transactions correspond to each ?