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

what nation came after spain ?
SELECT "nation" FROM table_204_308 WHERE "rank" = (SELECT "rank" FROM table_204_308 WHERE "nation" = 'spain') + 1
SELECT "nation" FROM "table_204_308" WHERE "rank" = (SELECT "rank" FROM "table_204_308" WHERE "nation" = 'spain') + 1