CREATE TABLE table_204_741 (id NUMBER, "rank" NUMBER, "name" CLOB, "nationality" CLOB, "1 , 62" CLOB, "1 , 67" CLOB, "1 , 72" CLOB, "1 , 75" CLOB, "notes" CLOB)

what name is just before thea lafond on the list ?
SELECT "name" FROM table_204_741 WHERE id = (SELECT id FROM table_204_741 WHERE "name" = 'thea lafond') - 1
SELECT "name" FROM "table_204_741" WHERE "id" = (SELECT "id" FROM "table_204_741" WHERE "name" = 'thea lafond') - 1