How many transaction does each account have? Show the number and account id.
SELECT count(*) ,  account_id FROM Financial_transactions
number of transactions per account = COUNT(*); showing number and account id = SELECT count(*) ,  account_id;