CREATE TABLE table_name_89 (player VARCHAR, nhl_team VARCHAR)

I want the player for NHL team for mighty ducks of anaheim
SELECT player FROM table_name_89 WHERE nhl_team = "mighty ducks of anaheim"
SELECT "player" FROM "table_name_89" WHERE "mighty ducks of anaheim" = "nhl_team"