CREATE TABLE table_204_783 (id NUMBER, "position" CLOB, "player" CLOB, "free agency\ tag" CLOB, "date signed" CLOB, "2013 team" CLOB)

who was the previous player signed before troy nolan ?
SELECT "player" FROM table_204_783 WHERE "date signed" < (SELECT "date signed" FROM table_204_783 WHERE "player" = 'troy nolan') ORDER BY "date signed" DESC LIMIT 1
SELECT "player" FROM "table_204_783" WHERE "date signed" < (SELECT "date signed" FROM "table_204_783" WHERE "player" = 'troy nolan') ORDER BY "date signed" DESC FETCH FIRST 1 ROWS ONLY