CREATE TABLE table_name_16 (comp VARCHAR, date VARCHAR)

What was the Comp on 2007-08-06?
SELECT comp FROM table_name_16 WHERE date = "2007-08-06"
SELECT "comp" FROM "table_name_16" WHERE "2007-08-06" = "date"