CREATE TABLE table_name_92 (date VARCHAR2, state VARCHAR2)

What was the date for Colorado?
SELECT date FROM table_name_92 WHERE state = "colorado"
SELECT "date" FROM "table_name_92" WHERE "colorado" = "state"