Database: customers_and_invoices
Question: Return the names and ids of each account, as well as the number of transactions.
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