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 was drafted after bob pierson ?
SELECT "player" FROM table_203_824 WHERE "pick #" = (SELECT "pick #" FROM table_203_824 WHERE "player" = 'bob pierson') + 1
SELECT "player" FROM "table_203_824" WHERE "pick #" = (SELECT "pick #" FROM "table_203_824" WHERE "player" = 'bob pierson') + 1