CREATE TABLE table_203_753 (id NUMBER, "rank" NUMBER, "name" CLOB, "caps" NUMBER, "goals" NUMBER, "years" CLOB)

which name is listed after alan smith ?
SELECT "name" FROM table_203_753 WHERE id = (SELECT id FROM table_203_753 WHERE "name" = 'alan smith') + 1
SELECT "name" FROM "table_203_753" WHERE "id" = (SELECT "id" FROM "table_203_753" WHERE "name" = 'alan smith') + 1