Table: eiac_schools
Columns: school
city
team_name
enrollment_08_09
ihsaa_class
ihsaa_class_football
county
year_joined_or_joining
previous_conference

Question: What year did the team from City of Aurora join?
SQL: SELECT AVG("year_joined_or_joining") FROM eiac_schools WHERE "city" = 'aurora'

Question: What was the total enrollment 08-09 of Franklin County?
SQL: SELECT COUNT("enrollment_08_09") FROM eiac_schools WHERE "school" = 'franklin county'

Question: What school has a team called the Pirates?
SQL: SELECT "school" FROM eiac_schools WHERE "team_name" = 'pirates'