CREATE TABLE table_204_235 (id NUMBER, "season" CLOB, "team" CLOB, "country" CLOB, "competition" CLOB, "matches" NUMBER, "goals" NUMBER)

what season has the most goals ?
SELECT "season" FROM table_204_235 ORDER BY "goals" DESC LIMIT 1
SELECT "season" FROM "table_204_235" ORDER BY "goals" DESC FETCH FIRST 1 ROWS ONLY