Table: yanke_conf_teams
Columns: institution
location
founded
type
joined
nickname
colors

Question: When did Northeastern University join?
SQL: SELECT SUM("joined") FROM yanke_conf_teams WHERE "institution" = 'northeastern university'

Question: Which type of institution is in Amherst, MA?
SQL: SELECT "type" FROM yanke_conf_teams WHERE "location" = 'amherst, ma'