Show the date of transaction where share count is larger than 100
select date_of_transaction from transactions where share_count > 100
What are the transaction IDs of those results?
select transaction_id from transactions where share_count > 100
Show date of transaction where amount of transaction larger than 1000
select date_of_transaction from transactions where amount_of_transaction > 1000