Table: northland_conferences
Columns: school
location
mascot
county
year_joined
previous_conference
year_left
conference_joined

Question: Of all the schools that left before 2003, what is the average year joined?
SQL: SELECT AVG("year_joined") FROM northland_conferences WHERE "year_left" < 2003

Question: What year did the Ingots, who left after 2007, join?
SQL: SELECT COUNT("year_joined") FROM northland_conferences WHERE "mascot" = 'ingots' AND "year_left" > 2007