Table: mid_state_conf
Columns: school
location
mascot
enrollment
ihsaa_class
county
year_joined
previous_conference

Question: Name the lowest Year Joined which has a Mascot of pioneers?
SQL: SELECT MIN("year_joined") FROM mid_state_conf WHERE "mascot" = 'pioneers'

Question: Name the IHSAA Class of Mascot of pioneers?
SQL: SELECT "ihsaa_class" FROM mid_state_conf WHERE "mascot" = 'pioneers'

Question: Name the IHSAA Class of 55 morgan and a School of mooresville?
SQL: SELECT "ihsaa_class" FROM mid_state_conf WHERE "county" = '55 morgan' AND "school" = 'mooresville'

Question: where is Mascot of quakers?
SQL: SELECT "location" FROM mid_state_conf WHERE "mascot" = 'quakers'

Question: What kind of IHSAA Class has a School of decatur central?
SQL: SELECT "ihsaa_class" FROM mid_state_conf WHERE "school" = 'decatur central'