hi! How many transactions have greater than 10 share count?
select count ( * ) from transactions where share_count > 10
What are their transaction type descriptions?
select t1.transaction_type_description from ref_transaction_types as t1 join transactions as t2 on t1.transaction_type_code = t2.transaction_type_code where t2.share_count < 10
What about their date?
select t2.date_of_transaction from ref_transaction_types as t1 join transactions as t2 on t1.transaction_type_code = t2.transaction_type_code where t2.share_count < 10