CREATE TABLE table_2840500_2 (player VARCHAR2, nhl_team VARCHAR2)

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