Would you show the transaction type descriptions if the share count is equal to or larger than 10?
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
showing transaction type descriptions for share count >= 10 involves joining two tables (Ref_Transaction_Types and TRANSACTIONS) on a common column (transaction_type_code); filtering the results where share_count is equal to or larger than 10;