Table: sagamore_conf
Columns: school
location
mascot
enrollment
ihsaa_class
county
year_joined

Question: Which Year Joined has an Enrollment smaller than 726, and a School of tri-west?
SQL: SELECT MAX("year_joined") FROM sagamore_conf WHERE "enrollment" < 726 AND "school" = 'tri-west'

Question: What is lebanon's enrollment?
SQL: SELECT AVG("enrollment") FROM sagamore_conf WHERE "school" = 'lebanon'

Question: What is the enrollment of the school whose mascot is hot dogs?
SQL: SELECT SUM("enrollment") FROM sagamore_conf WHERE "mascot" = 'hot dogs'

Question: When did crawfordsville join?
SQL: SELECT MAX("year_joined") FROM sagamore_conf WHERE "location" = 'crawfordsville'