What are the customers zip codes?
select t1.first_name, t1.last_name, t2.zip_postcode from customers as t1 join addresses as t2 on t1.customer_address_id = t2.address_id
What is zip code of customer with first name as Carole and last name as Bernhard?
select t2.zip_postcode from customers as t1 join addresses as t2 on t1.customer_address_id = t2.address_id where t1.first_name = "Carole" and t1.last_name = "Bernhard"