CREATE TABLE premises (premises_type VARCHAR(255), premise_id VARCHAR(255)); CREATE TABLE customer_addresses (address_type_code VARCHAR(255), premise_id VARCHAR(255))
Show the premise type and address type code for all customer addresses.
    
SQL: SELECT T2.premises_type, T1.address_type_code FROM customer_addresses AS T1 JOIN premises AS T2 ON T1.premise_id = T2.premise_id