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

Which team does Pierre Duguay play for?
SELECT "NHL team" FROM table_17467 WHERE "Player" = 'Pierre Duguay'
SELECT "NHL team" FROM "table_17467" WHERE "Player" = 'Pierre Duguay'