Table: mv_conf_institutions
Columns: institution
location
year_joined
affiliation
enrollment
mascot
colors

Question: What is the most recent year joined?
SQL: SELECT MAX("year_joined") FROM mv_conf_institutions

Question: what is the affiliation of the hilltoppers mascot?
SQL: SELECT "affiliation" FROM mv_conf_institutions WHERE "mascot" = 'Hilltoppers'

Question: what is the affiliation of the colors maroon and white? 
SQL: SELECT "affiliation" FROM mv_conf_institutions WHERE "colors" = 'Maroon and White'

Question: what is the number of enrollment of the central institution?
SQL: SELECT "enrollment" FROM mv_conf_institutions WHERE "institution" = 'Central'

Question: what is the name of the institution of the sparta, wi location?
SQL: SELECT "institution" FROM mv_conf_institutions WHERE "location" = 'Sparta, WI'

Question: in what year did the colors red and gold join?
SQL: SELECT COUNT("year_joined") FROM mv_conf_institutions WHERE "colors" = 'Red and Gold'