Table: conference_institutions_2
Columns: institution
location
founded
type
enrollment
nickname
joined
left
current_conference

Question: Name the joined for blue hose
SQL: SELECT "joined" FROM conference_institutions_2 WHERE "nickname" = 'Blue Hose'

Question: Name the maximum founded for blue hose
SQL: SELECT MAX("founded") FROM conference_institutions_2 WHERE "nickname" = 'Blue Hose'

Question: Name the maximum enrollment for st. andrews university
SQL: SELECT MAX("enrollment") FROM conference_institutions_2 WHERE "institution" = 'St. Andrews University'

Question: Name the current conference for 1974, 1989
SQL: SELECT "current_conference" FROM conference_institutions_2 WHERE "left" = '1974, 1989'