Show information for all customer addresses.
select * from customer_addresses
Show the address type code for all customer addresses.
select address_type_code from customer_addresses
Filter for distinctness.
select distinct address_type_code from customer_addresses