Table: player_stats_14
Columns: pick
mls_team
player
position
affiliation

Question: How many teams drafted players from the University of Maryland?
SQL: SELECT COUNT("mls_team") FROM player_stats_14 WHERE "affiliation" = 'University of Maryland'

Question: What MLS team drafted samuel appiah?
SQL: SELECT "mls_team" FROM player_stats_14 WHERE "player" = 'Samuel Appiah'

Question: What player was drafted by the philadelphia union?
SQL: SELECT "player" FROM player_stats_14 WHERE "mls_team" = 'Philadelphia Union'