CREATE TABLE table_204_805 (id DECIMAL, "name" TEXT, "club" TEXT, "date of departure" TEXT, "replacement" TEXT, "date of appointment" TEXT)

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