CREATE TABLE TRANSACTIONS (transaction_id VARCHAR, transaction_type_code VARCHAR)

Show all transaction ids with transaction code 'PUR'.
SELECT transaction_id FROM TRANSACTIONS WHERE transaction_type_code = 'PUR'
SELECT "transaction_id" FROM "TRANSACTIONS" WHERE "transaction_type_code" = 'PUR'