CREATE TABLE table_204_29 (id NUMBER, "rank" NUMBER, "lane" NUMBER, "name" CLOB, "nationality" CLOB, "time" CLOB, "notes" CLOB)

what is the previous name after james goddard ?
SELECT "name" FROM table_204_29 WHERE id = (SELECT id FROM table_204_29 WHERE "name" = 'james goddard') + 1
SELECT "name" FROM "table_204_29" WHERE "id" = (SELECT "id" FROM "table_204_29" WHERE "name" = 'james goddard') + 1