Table: football_teams_msfa
Columns: institution
location
founded
type
enrollment
joined
left
nickname
primary_conference_when_joining_the_msfa
current_primary_conference

Question: What school joined the conference in 1996-97 and left it in 2011-12?
SQL: SELECT "institution" FROM football_teams_msfa WHERE "joined" = '1996-97' AND "left" = '2011-12'

Question: What location has a school with enrollment of 850?
SQL: SELECT "location" FROM football_teams_msfa WHERE "enrollment" = 850

Question: How many schools left in 2002-03?
SQL: SELECT COUNT("location") FROM football_teams_msfa WHERE "left" = '2002-03'

Question: Which city has a school where the nickname is Pioneers?
SQL: SELECT "location" FROM football_teams_msfa WHERE "nickname" = 'Pioneers'

Question: What type of school has the nickname the Oilers?
SQL: SELECT "type" FROM football_teams_msfa WHERE "nickname" = 'Oilers'

Question: How many locations have a school that is nicknamed the Panthers?
SQL: SELECT COUNT("location") FROM football_teams_msfa WHERE "nickname" = 'Panthers'