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

What NHL team does Denis Desgagnes play for?
SELECT "NHL team" FROM table_2102 WHERE "Player" = 'Denis Desgagnes'
SELECT "NHL team" FROM "table_2102" WHERE "Player" = 'Denis Desgagnes'