SELECT s.state, cr.description
from States s
join CultRegionLookup crl on s.id = crl.stateid
join CulturalRegions cr on crl.culturalregionid = cr.culturalid
SELECT s.state
from States s
join CultRegionLookup crl on s.id = crl.stateid
join CulturalRegions cr on crl.stateid = cr.culturalid
where cr.description like "%cold%"
