CREATE TABLE table_2840500_8 (pick NUMBER, player VARCHAR2)

Name the most pick for evgeny korolev
SELECT MAX(pick) FROM table_2840500_8 WHERE player = "Evgeny Korolev"
SELECT MAX("pick") FROM "table_2840500_8" WHERE "Evgeny Korolev" = "player"