CREATE TABLE table_2840500_4 (position VARCHAR, player VARCHAR)

What position does Antti-Jussi Niemi play?
SELECT position FROM table_2840500_4 WHERE player = "Antti-Jussi Niemi"
SELECT "position" FROM "table_2840500_4" WHERE "Antti-Jussi Niemi" = "player"