query: SELECT T2.investor_id ,  T1.Investor_details FROM INVESTORS AS T1 JOIN TRANSACTIONS AS T2 ON T1.investor_id  =  T2.investor_id WHERE T2.transaction_type_code  =  "SALE" GROUP BY T2.investor_id HAVING COUNT(*)  >=  2
question: Show the ids and details of the investor have at least two transactions with type code "SALE".
query_toks: SELECT T2.investor_id , T1.Investor_details FROM INVESTORS AS T1 JOIN TRANSACTIONS AS T2 ON T1.investor_id = T2.investor_id WHERE T2.transaction_type_code = `` SALE '' GROUP BY T2.investor_id HAVING COUNT ( * ) > = 2
query_toks_no_value: select t2 . investor_id , t1 . investor_details from investors as t1 join transactions as t2 on t1 . investor_id = t2 . investor_id where t2 . transaction_type_code = value group by t2 . investor_id having count ( * ) > = value
question_toks: Show the ids and details of the investor have at least two transactions with type code "SALE".