CREATE TABLE table_6040 ("Pick #" FLOAT, "MLS Team" TEXT, "Player" TEXT, "Position" TEXT, "Affiliation" TEXT)

What position does the player from the MLS New England Revolution team hold?
SELECT "Position" FROM table_6040 WHERE "MLS Team" = 'new england revolution'
SELECT "Position" FROM "table_6040" WHERE "MLS Team" = 'new england revolution'