Table: mls_players
Columns: pick
mls_team
player
position
affiliation

Question: How many mls teams had player jamel wallace?
SQL: SELECT COUNT("mls_team") FROM mls_players WHERE "player" = 'Jamel Wallace'

Question: What university is kwaku nyamekye affiliated with?
SQL: SELECT "affiliation" FROM mls_players WHERE "player" = 'Kwaku Nyamekye'

Question: What university is houston dynamo affiliated with?
SQL: SELECT "affiliation" FROM mls_players WHERE "mls_team" = 'Houston Dynamo'

Question: What is the position of pick # 63?
SQL: SELECT "position" FROM mls_players WHERE "pick" = 63

Question: How many players are affiliated with indiana university?
SQL: SELECT COUNT("player") FROM mls_players WHERE "affiliation" = 'Indiana University'