Show the address type code for all customer addresses.
select address_type_code from customer_addresses
For each of them, also show the premise type.
select t2.premises_type, t1.address_type_code from customer_addresses as t1 join premises as t2 on t1.premise_id = t2.premise_id