CREATE TABLE TRANSACTIONS (investor_id VARCHAR, share_count INT)
CREATE TABLE INVESTORS (Investor_details VARCHAR, investor_id VARCHAR)

Show details of all investors if they make any transaction with share count 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
SELECT "T1"."Investor_details" FROM "INVESTORS" AS "T1" JOIN "TRANSACTIONS" AS "T2" ON "T1"."investor_id" = "T2"."investor_id" AND "T2"."share_count" > 100