CREATE TABLE table_203_793 (id NUMBER, "#" NUMBER, "date" CLOB, "venue" CLOB, "opponent" CLOB, "score" CLOB, "result" CLOB, "competition" CLOB)

who was the opponent before mexico ?
SELECT "opponent" FROM table_203_793 WHERE "date" < (SELECT "date" FROM table_203_793 WHERE "opponent" = 'mexico') ORDER BY "date" DESC LIMIT 1
SELECT "opponent" FROM "table_203_793" WHERE "date" < (SELECT "date" FROM "table_203_793" WHERE "opponent" = 'mexico') ORDER BY "date" DESC FETCH FIRST 1 ROWS ONLY