Table: mls_players
Columns: pick
mls_team
player
position
affiliation

Question: Which team has a midfielder of konrad warzycha?
SQL: SELECT "mls_team" FROM mls_players WHERE "position" = 'Midfielder' AND "player" = 'Konrad Warzycha'

Question: What is the pick number for the team toronto fc and affiliation is ldu quito?
SQL: SELECT MAX("pick") FROM mls_players WHERE "mls_team" = 'Toronto FC' AND "affiliation" = 'LDU Quito'

Question: Which MLS team picked player Jason Herrick?
SQL: SELECT "mls_team" FROM mls_players WHERE "player" = 'Jason Herrick'

Question: What position did the team new york red bulls pick?
SQL: SELECT "position" FROM mls_players WHERE "mls_team" = 'New York Red Bulls'

Question: What was the position when the affiliation is ldu quito?
SQL: SELECT "position" FROM mls_players WHERE "affiliation" = 'LDU Quito'