CREATE TABLE table_203_753 (id DECIMAL, "rank" DECIMAL, "name" TEXT, "caps" DECIMAL, "goals" DECIMAL, "years" TEXT)

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