What are the dates of those?
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
dates of those refers to date_of_transaction; condition share_count < 10; need to join Ref_Transaction_Types and TRANSACTIONS tables on transaction_type_code;