Database: customers_and_invoices
Question: Show the account name, id and the number of transactions for each account.
SQL:
SELECT T2.account_name ,  T1.account_id ,  count(*) FROM Financial_transactions AS T1 JOIN Accounts AS T2 ON T1.account_id  =  T2.account_id GROUP BY T1.account_id