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

who has the largest amount of apps ?
SELECT "name" FROM table_204_340 ORDER BY "apps" DESC LIMIT 1
SELECT "name" FROM "table_204_340" ORDER BY "apps" DESC FETCH FIRST 1 ROWS ONLY