ok i see the transactions of the sales. and then what are the ones that were purchases?
select transaction_id from Transactions where transaction_type_code = 'PUR'
transactions that were purchases refers to transaction_type_code = 'PUR';