CREATE TABLE table_1004033_1 (college VARCHAR2, team VARCHAR2)

What college did the Rookie of the Year from the Columbus Crew attend?
SELECT college FROM table_1004033_1 WHERE team = "Columbus Crew"
SELECT "college" FROM "table_1004033_1" WHERE "Columbus Crew" = "team"