CREATE TABLE table_204_296 (id NUMBER, "rank" NUMBER, "athlete" CLOB, "qual" NUMBER, "final" NUMBER, "total" NUMBER, "notes" CLOB)

which athlete has the most total ?
SELECT "athlete" FROM table_204_296 ORDER BY "total" DESC LIMIT 1
SELECT "athlete" FROM "table_204_296" ORDER BY "total" DESC FETCH FIRST 1 ROWS ONLY