Table: mls_rookie_of_year
Columns: season
player
position
nationality
team
draft_pick
draft_class
college

Question: When did the Metrostars have their first Rookie of the Year winner?
SQL: SELECT MIN("season") FROM mls_rookie_of_year WHERE "team" = 'MetroStars'

Question: What college did the Rookie of the Year from the Columbus Crew attend?
SQL: SELECT "college" FROM mls_rookie_of_year WHERE "team" = 'Columbus Crew'

Question: How many teams had a #1 draft pick that won the Rookie of the Year Award?
SQL: SELECT COUNT("team") FROM mls_rookie_of_year WHERE "draft_pick" = '1'

Question: What position did the #10 draft pick play?
SQL: SELECT "position" FROM mls_rookie_of_year WHERE "draft_pick" = '10'