Table: mls_draft_2004
Columns: pick
mls_team
player
position
affiliation

Question: What position did the MLS team metrostars pick?
SQL: SELECT "position" FROM mls_draft_2004 WHERE "mls_team" = 'metrostars'

Question: What MLS team is affiliated with yale university?
SQL: SELECT "mls_team" FROM mls_draft_2004 WHERE "affiliation" = 'yale university'

Question: What affiliations have Pick #s under 32?
SQL: SELECT "affiliation" FROM mls_draft_2004 WHERE "pick" < 32

Question: What players have a position of F?
SQL: SELECT "player" FROM mls_draft_2004 WHERE "position" = 'f'