CREATE TABLE premises (premises_type VARCHAR2, premise_id VARCHAR2)
CREATE TABLE customer_addresses (address_type_code VARCHAR2, premise_id VARCHAR2)

Show the premise type and address type code for all customer addresses.
SELECT T2.premises_type, T1.address_type_code FROM customer_addresses AS T1 JOIN premises AS T2 ON T1.premise_id = T2.premise_id
SELECT "T2"."premises_type", "T1"."address_type_code" FROM "customer_addresses" "T1" JOIN "premises" "T2" ON "T1"."premise_id" = "T2"."premise_id"