CREATE TABLE table_203_692 (id NUMBER, "name" CLOB, "pos." CLOB, "caps" NUMBER, "goals" NUMBER, "club" CLOB)

who has the most goals ?
SELECT "name" FROM table_203_692 ORDER BY "goals" DESC LIMIT 1
SELECT "name" FROM "table_203_692" ORDER BY "goals" DESC FETCH FIRST 1 ROWS ONLY