CREATE TABLE table_1213511_6 (nhl_team VARCHAR2, player VARCHAR2)

Which team does Pierre Duguay play for?
SELECT nhl_team FROM table_1213511_6 WHERE player = "Pierre Duguay"
SELECT "nhl_team" FROM "table_1213511_6" WHERE "Pierre Duguay" = "player"