CREATE TABLE table_17972136_1 (opponent VARCHAR2, date VARCHAR2)

What is the opponent played on October 4?
SELECT opponent FROM table_17972136_1 WHERE date = "October 4"
SELECT "opponent" FROM "table_17972136_1" WHERE "October 4" = "date"