CREATE TABLE table_204_340 (id NUMBER, "name" CLOB, "year inducted" NUMBER, "position" CLOB, "apps" NUMBER, "goals" NUMBER)

what player has the most number of goals ?
SELECT "name" FROM table_204_340 ORDER BY "goals" DESC LIMIT 1
SELECT "name" FROM "table_204_340" ORDER BY "goals" DESC FETCH FIRST 1 ROWS ONLY