Table: coast_conference_institutions
Columns: institution
location
founded
type
enrollment
nickname
joined

Question: How many nicknames were associated with Milton, Massachusetts?
SQL: SELECT COUNT("nickname") FROM coast_conference_institutions WHERE "location" = 'Milton, Massachusetts'

Question: Where is the Eastern Nazarene College located?
SQL: SELECT "location" FROM coast_conference_institutions WHERE "institution" = 'Eastern Nazarene College'

Question: How many years are listed under joined for the Nor'easters?
SQL: SELECT COUNT("joined") FROM coast_conference_institutions WHERE "nickname" = 'Nor''easters'

Question: What location contains a school that has an enrollment of 2686?
SQL: SELECT "location" FROM coast_conference_institutions WHERE "enrollment" = 2686

Question: In what year did the Lions join?
SQL: SELECT MIN("joined") FROM coast_conference_institutions WHERE "nickname" = 'Lions'