CREATE TABLE table_203_805 (id NUMBER, "year" NUMBER, "player" CLOB, "position" CLOB, "high school" CLOB, "college" CLOB)

who was the player of the year before robert smith ?
SELECT "player" FROM table_203_805 WHERE "year" = (SELECT "year" FROM table_203_805 WHERE "player" = 'robert smith') - 1
SELECT "player" FROM "table_203_805" WHERE "year" = (SELECT "year" FROM "table_203_805" WHERE "player" = 'robert smith') - 1