CREATE TABLE table_24560733_1 (opponent VARCHAR2, date VARCHAR2)

Who was the opponent on Oct. 4?
SELECT opponent FROM table_24560733_1 WHERE date = "Oct. 4"
SELECT "opponent" FROM "table_24560733_1" WHERE "Oct. 4" = "date"