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

nation that earned the most total medals after spain
SELECT "nation" FROM table_204_107 WHERE "total" < (SELECT "total" FROM table_204_107 WHERE "nation" = 'spain') ORDER BY "total" DESC LIMIT 1
SELECT "nation" FROM "table_204_107" WHERE "total" < (SELECT "total" FROM "table_204_107" WHERE "nation" = 'spain') ORDER BY "total" DESC FETCH FIRST 1 ROWS ONLY