Database: customers_and_invoices
Question: How many transaction does each account have? Show the number and account id.
SQL:
SELECT count(*) ,  account_id FROM Financial_transactions