Table: mls_draft_2010
Columns: pick
mls_team
player
position
affiliation

Question: How many picks are there with an affiliation is the University of California Norcal Lamorinda United?
SQL: SELECT COUNT("pick") FROM mls_draft_2010 WHERE "affiliation" = 'University of California NorCal Lamorinda United'

Question: What team does Seth Sinovic play for?
SQL: SELECT "mls_team" FROM mls_draft_2010 WHERE "player" = 'Seth Sinovic'

Question: How many players have an affiliation with University of Maryland?
SQL: SELECT COUNT("player") FROM mls_draft_2010 WHERE "affiliation" = 'University of Maryland'