ค้นหาชื่อลูกค้าที่อาศัยอยู่ในโคโลราโด?ไม่จำเป็นต้องใช้ทุกตาราง
Find the name of customers who are living in Colorado?It is not neccessary to use all the tables.
 customer_addresses:  (customer_id [ VARCHAR ] address_id [ VARCHAR) ]
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"