CREATE TABLE table_204_924 (id NUMBER, "match" NUMBER, "date" CLOB, "ground" CLOB, "opponent" CLOB, "score1" CLOB, "pos." NUMBER, "pts." NUMBER, "gd" NUMBER)

what was the last opponent the club played in august ?
SELECT "opponent" FROM table_204_924 WHERE "date" = 8 ORDER BY "date" DESC LIMIT 1
SELECT "opponent" FROM "table_204_924" WHERE "date" = 8 ORDER BY "date" DESC FETCH FIRST 1 ROWS ONLY