CREATE TABLE table_204_461 (id NUMBER, "res." CLOB, "record" CLOB, "opponent" CLOB, "method" CLOB, "event" CLOB, "date" CLOB, "round" NUMBER, "time" CLOB, "location" CLOB, "notes" CLOB)

zwicker faced tom hubert on october 15th , 2005 , who did he face before him ?
SELECT "opponent" FROM table_204_461 WHERE "date" < (SELECT "date" FROM table_204_461 WHERE "opponent" = 'tom hubert') ORDER BY "date" DESC LIMIT 1
SELECT "opponent" FROM "table_204_461" WHERE "date" < (SELECT "date" FROM "table_204_461" WHERE "opponent" = 'tom hubert') ORDER BY "date" DESC FETCH FIRST 1 ROWS ONLY