Hi there!  Can you show me a list of all customer IDs for customers not located in the state of California?
select customer_id from customers except select t1.customer_id 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 = 'California'
Thanks!  Can you update this list to show both the city name and state associated with each of these customers?
select t1.customer_id, t3.city, t3.state_province_county 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 ! = 'California'