CREATE TABLE table_203_767 (id NUMBER, "season" CLOB, "club" CLOB, "league" CLOB, "apps" NUMBER, "goals" NUMBER)

the team with the most goals
SELECT "club" FROM table_203_767 ORDER BY "goals" DESC LIMIT 1
SELECT "club" FROM "table_203_767" ORDER BY "goals" DESC FETCH FIRST 1 ROWS ONLY