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
Show the account id and name with at least 4 transactions.
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
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 ( * ) > = value
Show the account id and name with at least 4 transactions .