user: ### NOW ANSWER:
Question: How many picks are there with an affiliation is the University of California NorCal Lamorinda United?
Columns: ['Pick #', 'MLS Team', 'Player', 'Position', 'Affiliation']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [17.0, 'Philadelphia Union', 'Toni Ståhl', 'Midfielder', 'University of Connecticut']
SQL:

assistant: SELECT COUNT("Pick #") FROM "Table" WHERE "Affiliation" = 'University of California NorCal Lamorinda United';