CREATE TABLE table_10235 ("Date" CLOB, "Venue" CLOB, "Opponent" CLOB, "Result" CLOB, "Competition" CLOB)

What opponent played on 07-09-2012?
SELECT "Opponent" FROM table_10235 WHERE "Date" = '07-09-2012'
SELECT "Opponent" FROM "table_10235" WHERE "Date" = '07-09-2012'