CREATE TABLE table_1965650_8 (nhl_team VARCHAR2, player VARCHAR2)

What NHL team does Denis Desgagnes play for?
SELECT nhl_team FROM table_1965650_8 WHERE player = "Denis Desgagnes"
SELECT "nhl_team" FROM "table_1965650_8" WHERE "Denis Desgagnes" = "player"