Database: customers_and_invoices
Question: Show the account id with most number of transactions.
SQL:
SELECT account_id FROM Financial_transactions GROUP BY account_id ORDER BY count(*) DESC LIMIT 1