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