What about just the ones with the transaction type code SALE?
Select date_of_transaction from transactions where transaction_type_code  =  "SALE"
transaction type code SALE refers to transaction_type_code = 'SALE'; date of transaction refers to date_of_transaction;