CREATE TABLE transactions_lots (transaction_id DECIMAL, lot_id DECIMAL)
CREATE TABLE transactions (transaction_id DECIMAL, investor_id DECIMAL, transaction_type_code TEXT, date_of_transaction TIME, amount_of_transaction DECIMAL, share_count TEXT, other_details TEXT)
CREATE TABLE ref_transaction_types (transaction_type_code TEXT, transaction_type_description TEXT)
CREATE TABLE lots (lot_id DECIMAL, investor_id DECIMAL, lot_details TEXT)
CREATE TABLE purchases (purchase_transaction_id DECIMAL, purchase_details TEXT)
CREATE TABLE sales (sales_transaction_id DECIMAL, sales_details TEXT)
CREATE TABLE investors (investor_id DECIMAL, investor_details TEXT)

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