What are the states or counties of the address of the stores with marketing region code "CA"?
create table addresses (state_county varchar, address_id varchar, PRIMARY KEY (state_county)); create table stores (address_id varchar, marketing_region_code varchar, PRIMARY KEY (address_id))
select t1.state_county from addresses as t1 join stores as t2 on t1.address_id = t2.address_id where t2.marketing_region_code = "ca"