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

Question: Which school has an enrollment of A and had lost river as their previous conference?
SQL: SELECT "school" FROM southern_ath_conf_in WHERE "previous_conference" = 'lost river' AND "enrollment" = 'a'

Question: What is the average year joined of the 277 county?
SQL: SELECT AVG("year_joined") FROM southern_ath_conf_in WHERE "county" = 277

Question: What is the IHSAA class of the county that is less than 228?
SQL: SELECT "ihsaa_class" FROM southern_ath_conf_in WHERE "county" < 228