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

Question: Which Previous conference has a Year joined smaller than 1976, and an IHSAA Class of A?
SQL: SELECT "previous_conference" FROM three_rivers_conference_schools WHERE "year_joined" < 1976 AND "ihsaa_class" = 'a'

Question: Which Enrollment has a Mascot of norsemen?
SQL: SELECT SUM("enrollment") FROM three_rivers_conference_schools WHERE "mascot" = 'norsemen'

Question: Which Mascot has a Previous conference of independents, and a Location of akron?
SQL: SELECT "mascot" FROM three_rivers_conference_schools WHERE "previous_conference" = 'independents' AND "location" = 'akron'

Question: Which IHSAA Class has a Mascot of wildcats?
SQL: SELECT "ihsaa_class" FROM three_rivers_conference_schools WHERE "mascot" = 'wildcats'

Question: Which School in Wabash has a Mascot of knights?
SQL: SELECT "school" FROM three_rivers_conference_schools WHERE "location" = 'wabash' AND "mascot" = 'knights'