Show the maximum share count of transactions where the amount is smaller than 10000
CREATE TABLE TRANSACTIONS (share_count INTEGER, amount_of_transaction INTEGER)
[SQL] SELECT MAX(share_count) FROM TRANSACTIONS WHERE amount_of_transaction < 10000 [/SQL]