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

Question: what is the school that left in 1966?
SQL: SELECT "school" FROM conference_history WHERE "year_left" = 1966

Question: what is the mascot for moores hill that joined later than 1952?
SQL: SELECT "mascot" FROM conference_history WHERE "year_joined" > 1952 AND "school" = 'moores hill'

Question: what is the conference joined for the county 69 ripley in 1952 in versailles?
SQL: SELECT "conference_joined" FROM conference_history WHERE "county" = '69 ripley' AND "year_joined" = 1952 AND "location" = 'versailles'

Question: who is the mascot of the county 78 switzerland?
SQL: SELECT "mascot" FROM conference_history WHERE "county" = '78 switzerland'