SELECT count(*) FROM addresses WHERE state_province_county  =  "Colorado"
How many cities are there in state "Colorado"?
SELECT count ( * ) FROM addresses WHERE state_province_county = `` Colorado ''
select count ( * ) from addresses where state_province_county = value
How many cities are there in state `` Colorado '' ?