Would you show the transaction type descriptions if the share count is smaller 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 transactions with share count smaller than 10 involves joining a transaction types reference table (Ref_Transaction_Types) with a transactions table (TRANSACTIONS) on a common transaction type code, and filtering for records where share_count is less than 10;