CREATE TABLE table_204_93 (id NUMBER, "round" NUMBER, "pick" NUMBER, "player" CLOB, "position" CLOB, "nationality" CLOB, "team" CLOB, "college" CLOB)

college attended of previous pick to bob anderegg
SELECT "college" FROM table_204_93 WHERE "pick" = (SELECT "pick" FROM table_204_93 WHERE "player" = 'bob anderegg') - 1
SELECT "college" FROM "table_204_93" WHERE "pick" = (SELECT "pick" FROM "table_204_93" WHERE "player" = 'bob anderegg') - 1