Hello There! Can you provide me with a list of all customer names?
select customer_name from customers
Thank you for that!  Can you filter that list to show only the customers living in Colorado?
select t1.customer_name from customers as t1 join customer_addresses as t2 on t1.customer_id = t2.customer_id join addresses as t3 on t2.address_id = t3.address_id where t3.state_province_county = "Colorado"
Great!  Can you update this list to show their address content, city, and zip code?
select t1.customer_name, t3.address_content, t3.city, t3.zip_postcode from customers as t1 join customer_addresses as t2 on t1.customer_id = t2.customer_id join addresses as t3 on t2.address_id = t3.address_id where t3.state_province_county = "Colorado"