How many cities are there in state "Colorado"?
create table addresses (state_province_county varchar, PRIMARY KEY (state_province_county))
select count(*) from addresses where state_province_county = "colorado"