CREATE TABLE table_name_97 (mls_team VARCHAR, affiliation VARCHAR)

What MLS team is affiliated with yale university?
SELECT mls_team FROM table_name_97 WHERE affiliation = "yale university"
SELECT "mls_team" FROM "table_name_97" WHERE "affiliation" = "yale university"