Show details of all investors that made transactions with sgare greater than 100?
select t1.investor_details from investors as t1 join transactions as t2 on t1.investor_id = t2.investor_id where t2.share_count > 100
What is the transaction id of all investors that made transactions with sgare greater than 100?
select t2.transaction_id from investors as t1 join transactions as t2 on t1.investor_id = t2.investor_id where t2.share_count > 100
What is the transaction type code of transaction id 2?
select t2.transaction_type_code from investors as t1 join transactions as t2 on t1.investor_id = t2.investor_id where t2.transaction_id = 2