CREATE TABLE table_2840500_2 (nhl_team VARCHAR2, player VARCHAR2)

Which team drafted Travis Brigley?
SELECT nhl_team FROM table_2840500_2 WHERE player = "Travis Brigley"
SELECT "nhl_team" FROM "table_2840500_2" WHERE "Travis Brigley" = "player"