user: ### NOW ANSWER:
Question: What is the pick number for the player Chris Gomez?
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 SUM("Pick #") FROM "Table" WHERE "Player" = 'Chris Gomez';