-- Database schema
| Investors : investor_id [ INT ] primary_key , Investor_details [ TEXT ] | Lots : lot_id [ INT ] primary_key , investor_id [ INT ] Lots.investor_id = Investors.investor_id , lot_details [ TEXT ] | Ref_Transaction_Types : transaction_type_code [ TEXT ] primary_key , transaction_type_description [ TEXT ] | Transactions : transaction_id [ INT ] primary_key , investor_id [ INT ] Transactions.investor_id = Investors.investor_id , transaction_type_code [ TEXT ] Transactions.transaction_type_code = Ref_Transaction_Types.transaction_type_code , date_of_transaction [ TEXT ] , amount_of_transaction [ INT ] , share_count [ TEXT ] , other_details [ TEXT ] | Sales : sales_transaction_id [ INT ] primary_key Sales.sales_transaction_id = Transactions.transaction_id , sales_details [ TEXT ] | Purchases : purchase_transaction_id [ INT ] Purchases.purchase_transaction_id = Transactions.transaction_id , purchase_details [ TEXT ] | Transactions_Lots : transaction_id [ INT ] Transactions_Lots.transaction_id = Transactions.transaction_id , lot_id [ INT ] Transactions_Lots.lot_id = Lots.lot_id |
-- -- Show the ids and details of the investors who have at least two transactions with type code "SALE".

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;