Table: mls_draft_2005_2
Columns: pick
mls_team
player
position
affiliation

Question: What position does the player from the MLS New England Revolution team hold?
SQL: SELECT "position" FROM mls_draft_2005_2 WHERE "mls_team" = 'new england revolution'

Question: Which MLS team had a pick number of 32?
SQL: SELECT "mls_team" FROM mls_draft_2005_2 WHERE "pick" = 32

Question: What is the pick number for the player Chris Gomez?
SQL: SELECT SUM("pick") FROM mls_draft_2005_2 WHERE "player" = 'chris gomez'

Question: Which position is the MLS team, Los Angeles Galaxy in?
SQL: SELECT "position" FROM mls_draft_2005_2 WHERE "mls_team" = 'los angeles galaxy'