CREATE TABLE table_204_799 (id NUMBER, "name" CLOB, "built" CLOB, "listed" CLOB, "location" CLOB, "county" CLOB, "type" CLOB)

what is the next name after bayou pierre bridge ?
SELECT "name" FROM table_204_799 WHERE id = (SELECT id FROM table_204_799 WHERE "name" = 'bayou pierre bridge' ORDER BY id DESC LIMIT 1) + 1
SELECT "name" FROM "table_204_799" WHERE "id" = (SELECT "id" FROM "table_204_799" WHERE "name" = 'bayou pierre bridge' ORDER BY "id" DESC FETCH FIRST 1 ROWS ONLY) + 1