Table: conference_schools_6
Columns: school
location
mascot
county
year_joined
year_left
conference_joined

Question: What's the highest Year Left that's got a Conference Joined of Sagamore with a Year Joined larger than 1942?
SQL: SELECT MAX("year_left") FROM conference_schools_6 WHERE "conference_joined" = 'sagamore' AND "year_joined" > 1942

Question: What's the highest Year Left for the School of Danville?
SQL: SELECT MAX("year_left") FROM conference_schools_6 WHERE "school" = 'danville'