CREATE TABLE TRANSACTIONS (transaction_id VARCHAR(255), transaction_type_code VARCHAR(255))
Show all transaction ids with transaction code 'PUR'.
    
SQL: SELECT transaction_id FROM TRANSACTIONS WHERE transaction_type_code = 'PUR'