What are the ids of addresses in Colorado state?
select address_id from addresses where state_province_county = "Colorado"
Tell me the ids of customers who live there.
select t2.customer_id from customer_addresses as t2 join addresses as t3 on t2.address_id = t3.address_id where t3.state_province_county = "Colorado"
What are the names of these customers?
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"