Show the maximum share count of transactions where the amount is smaller than 10000
CREATE TABLE TRANSACTIONS (share_count INTEGER, amount_of_transaction INTEGER)
SELECT MAX(share_count) FROM TRANSACTIONS WHERE amount_of_transaction < 10000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE TRANSACTIONS (share_count INTEGER, amount_of_transaction INTEGER) Question: Show the maximum share count of transactions where the amount is smaller than 10000 [/INST] SELECT MAX(share_count) FROM TRANSACTIONS WHERE amount_of_transaction < 10000 </s>