CREATE TABLE table_204_805 (id NUMBER, "name" CLOB, "club" CLOB, "date of departure" CLOB, "replacement" CLOB, "date of appointment" CLOB)

what name is just previous to surasak tansurat on the list ?
SELECT "name" FROM table_204_805 WHERE id = (SELECT id FROM table_204_805 WHERE "name" = 'surasak tansurat') - 1
SELECT "name" FROM "table_204_805" WHERE "id" = (SELECT "id" FROM "table_204_805" WHERE "name" = 'surasak tansurat') - 1