Table schema:
CREATE TABLE table_2840500_2 (player VARCHAR, nhl_team VARCHAR)

Question: How many players were drafted by the Edmonton Oilers?
SQL: SELECT COUNT(player) FROM table_2840500_2 WHERE nhl_team = "Edmonton Oilers"