Table: eiac_teams
Columns: school
city
team_name
county
year_joined
year_left

Question: Which school left in 1968 and has the team name of Panthers?
SQL: SELECT "school" FROM eiac_teams WHERE "team_name" = 'panthers' AND "year_left" = '1968'

Question: What year did a team from North Dearborn leave?
SQL: SELECT "year_left" FROM eiac_teams WHERE "school" = 'north dearborn'

Question: Which city has a school of North Vernon and a county of 40 Jennings?
SQL: SELECT "city" FROM eiac_teams WHERE "county" = '40 jennings' AND "school" = 'north vernon'

Question: What year did a school from Jennings County join?
SQL: SELECT "year_joined" FROM eiac_teams WHERE "school" = 'jennings county'

Question: Which school are the Red Devils from?
SQL: SELECT "school" FROM eiac_teams WHERE "team_name" = 'red devils'

Question: Which school comes from Brookville?
SQL: SELECT "school" FROM eiac_teams WHERE "city" = 'brookville'