How many transactions are there?
select count(date_of_transaction) from transactions
Among these transactions, how many of them have a share count of at least 100 or an amount bigger than 100?
select count(date_of_transaction) from transactions where share_count >= 100 or amount_of_transaction >= 100
Can you please show their dates?
select date_of_transaction from transactions where share_count >= 100 or amount_of_transaction >= 100