CREATE TABLE table_203_824 (id NUMBER, "pick #" NUMBER, "player" CLOB, "position" CLOB, "nationality" CLOB, "nhl team" CLOB, "college/junior/club team" CLOB)

which player is listed previous to joe reekie ?
SELECT "player" FROM table_203_824 WHERE id = (SELECT id FROM table_203_824 WHERE "player" = 'joe reekie') - 1
SELECT "player" FROM "table_203_824" WHERE "id" = (SELECT "id" FROM "table_203_824" WHERE "player" = 'joe reekie') - 1