Table: tec_schools
Columns: school
location
mascot
size
ihsaa_class
county
year_joined
previous_conference

Question: What's the size of Centerville in 89 Wayne county with an IHSAA class of AA in the year before 1974?
SQL: SELECT "size" FROM tec_schools WHERE "year_joined" < 1974 AND "ihsaa_class" = 'aa' AND "county" = '89 wayne' AND "school" = 'centerville'

Question: What's the year that Hagerstown joined?
SQL: SELECT "year_joined" FROM tec_schools WHERE "school" = 'hagerstown'

Question: What county is Fountain City?
SQL: SELECT "county" FROM tec_schools WHERE "location" = 'fountain city'

Question: What's the previous conference of Fountain City with a size more than 287?
SQL: SELECT "previous_conference" FROM tec_schools WHERE "size" > 287 AND "location" = 'fountain city'