CREATE TABLE table_204_822 (id NUMBER, "rank" NUMBER, "nation" CLOB, "gold" NUMBER, "silver" NUMBER, "bronze" NUMBER, "total" NUMBER)

the top ranked nation for total medals won
SELECT "nation" FROM table_204_822 ORDER BY "total" DESC LIMIT 1
SELECT "nation" FROM "table_204_822" ORDER BY "total" DESC FETCH FIRST 1 ROWS ONLY