Schema: CREATE TABLE table_name_97 (mls_team VARCHAR, affiliation VARCHAR)
Question: What MLS team is affiliated with yale university?
SQL: SELECT mls_team FROM table_name_97 WHERE affiliation = "yale university"