CREATE TABLE table_203_160 (id NUMBER, "rank" NUMBER, "heat" NUMBER, "nation" CLOB, "competitors" CLOB, "time" CLOB, "notes" CLOB)

which nation came before spain ?
SELECT "nation" FROM table_203_160 WHERE "rank" = (SELECT "rank" FROM table_203_160 WHERE "nation" = 'spain') - 1
SELECT "nation" FROM "table_203_160" WHERE "rank" = (SELECT "rank" FROM "table_203_160" WHERE "nation" = 'spain') - 1