Table: kac_schools
Columns: high_school
location
founded
affiliation
enrollment
nickname
division

Question: What High School with a nickname of S Eagle has a Division of crest?
SQL: SELECT "high_school" FROM kac_schools WHERE "division" = 'crest' AND "nickname" = 's eagle'

Question: What is the affiliation of a location called Issaquah?
SQL: SELECT "affiliation" FROM kac_schools WHERE "location" = 'issaquah'

Question: What is the affiliation of a high school in Issaquah that was founded in less than 1965?
SQL: SELECT "affiliation" FROM kac_schools WHERE "founded" < 1965 AND "high_school" = 'issaquah'