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