CREATE TABLE addresses (state_province_county VARCHAR2)

How many cities are there in state 'Colorado'?
SELECT COUNT(*) FROM addresses WHERE state_province_county = "Colorado"
SELECT COUNT(*) FROM "addresses" WHERE "Colorado" = "state_province_county"