Show the account id with most number of transactions.
SELECT account_id FROM Financial_transactions GROUP BY account_id ORDER BY count(*) DESC LIMIT 1
account with the most number of transactions refers to MAX(COUNT(transaction_id));