CREATE TABLE table_name_49 (nhl_team VARCHAR, pick__number VARCHAR)

Which NHL team got pick 89?
SELECT nhl_team FROM table_name_49 WHERE pick__number = "89"
SELECT "nhl_team" FROM "table_name_49" WHERE "89" = "pick__number"