SELECT max(share_count) FROM TRANSACTIONS WHERE amount_of_transaction  <  10000
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 < value
Show the maximum share count of transactions where the amount is smaller than 10000