Show all transaction ids with transaction code 'PUR'.
create table transactions (transaction_id varchar, transaction_type_code varchar, PRIMARY KEY (transaction_id))
select transaction_id from transactions where transaction_type_code = 'pur'