CREATE TABLE table_2886617_8 (player VARCHAR, nhl_team VARCHAR)

Who did Edmonton Oilers get for their draft pick?
SELECT player FROM table_2886617_8 WHERE nhl_team = "Edmonton Oilers"
SELECT "player" FROM "table_2886617_8" WHERE "Edmonton Oilers" = "nhl_team"