CREATE TABLE table_204_29 (id DECIMAL, "rank" DECIMAL, "lane" DECIMAL, "name" TEXT, "nationality" TEXT, "time" TEXT, "notes" TEXT)

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