Database: customers_and_invoices
Question: What are the ids and names of accounts with 4 or more transactions?
SQL:
SELECT T1.account_id ,  T2.account_name FROM Financial_transactions AS T1 JOIN Accounts AS T2 ON T1.account_id  =  T2.account_id GROUP BY T1.account_id HAVING count(*)  >=  4