Database: customers_campaigns_ecommerce
Question: 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