CREATE TABLE table_47869 ("Date" CLOB, "Opponent" CLOB, "Score" CLOB, "Result" CLOB, "Record" CLOB)

WHAT OPPONENT HAD A DATE OF SEPTEMBER 28?
SELECT "Opponent" FROM table_47869 WHERE "Date" = 'september 28'
SELECT "Opponent" FROM "table_47869" WHERE "Date" = 'september 28'