CREATE TABLE customers (customer_name VARCHAR2, customer_id VARCHAR2)
CREATE TABLE customer_addresses (customer_id VARCHAR2, address_id VARCHAR2)
CREATE TABLE addresses (address_id VARCHAR2, state_province_county VARCHAR2)

Find the name of customers who are 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"
SELECT "t1"."customer_name" FROM "customers" "t1" JOIN "customer_addresses" "t2" ON "t1"."customer_id" = "t2"."customer_id" JOIN "addresses" "t3" ON "Colorado" = "t3"."state_province_county" AND "t2"."address_id" = "t3"."address_id"