CREATE TABLE table_name_84 (comp VARCHAR, date VARCHAR)

Which Comp is on 2004-10-17?
SELECT comp FROM table_name_84 WHERE date = "2004-10-17"
SELECT "comp" FROM "table_name_84" WHERE "2004-10-17" = "date"