CREATE TABLE table_1473672_2 (nhl_team VARCHAR, player VARCHAR)

What nhl team does stan weir play for?
SELECT nhl_team FROM table_1473672_2 WHERE player = "Stan Weir"
SELECT "nhl_team" FROM "table_1473672_2" WHERE "Stan Weir" = "player"