CREATE TABLE transactions_lots (transaction_id DECIMAL, lot_id DECIMAL)
CREATE TABLE purchases (purchase_transaction_id DECIMAL, purchase_details TEXT)
CREATE TABLE sales (sales_transaction_id DECIMAL, sales_details TEXT)
CREATE TABLE lots (lot_id DECIMAL, investor_id DECIMAL, lot_details TEXT)
CREATE TABLE ref_transaction_types (transaction_type_code TEXT, transaction_type_description TEXT)
CREATE TABLE investors (investor_id DECIMAL, investor_details TEXT)
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)

Show the maximum share count of transactions where the amount is smaller than 10000
SELECT MAX(share_count) FROM transactions WHERE amount_of_transaction < 10000
SELECT MAX("share_count") FROM "transactions" WHERE "amount_of_transaction" < 10000