CREATE TABLE table_29988 ("Pick" FLOAT, "Player" CLOB, "Position" CLOB, "Nationality" CLOB, "NHL team" CLOB, "College/junior/club team" CLOB)

For player is adam wiesel mention all the college/junior/club team
SELECT "College/junior/club team" FROM table_29988 WHERE "Player" = 'Adam Wiesel'
SELECT "College/junior/club team" FROM "table_29988" WHERE "Player" = 'Adam Wiesel'