CREATE TABLE table_204_334 (id NUMBER, "opposition" CLOB, "matches" NUMBER, "won" NUMBER, "drawn" NUMBER, "lost" NUMBER, "for" NUMBER, "against" NUMBER, "win%" CLOB)

who is the last opposition ?
SELECT "opposition" FROM table_204_334 ORDER BY id DESC LIMIT 1
SELECT "opposition" FROM "table_204_334" ORDER BY "id" DESC FETCH FIRST 1 ROWS ONLY