CREATE TABLE TRANSACTIONS (share_count NUMBER, amount_of_transaction NUMBER)

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