user: ### NOW ANSWER:
Question: What position does the player from the MLS New England Revolution team hold?
Columns: ['Pick #', 'MLS Team', 'Player', 'Position', 'Affiliation']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [25.0, 'MetroStars', 'Chris Corcoran', 'M', 'St. Johns University']
SQL:

assistant: SELECT "Position" FROM "Table" WHERE "MLS Team" = 'New England Revolution';