Show the dates of transactions if the share count is bigger than 100.
select date_of_transaction from transactions where share_count > 100
Show the dates of transactions if the amount is bigger than 1000.
select date_of_transaction from transactions where amount_of_transaction > 1000
What are the dates of the transactions in these two groups?
select date_of_transaction from transactions where share_count > 100 or amount_of_transaction > 1000