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

Question: What year was Skyline High School founded?
SQL: SELECT COUNT("founded") FROM kac_highschools WHERE "high_school" = 'Skyline'

Question: How many enrollment figures are provided for Roosevelt High School?
SQL: SELECT COUNT("enrollment") FROM kac_highschools WHERE "high_school" = 'Roosevelt'

Question: Which location has a team that is nicknamed the Vikings?
SQL: SELECT "location" FROM kac_highschools WHERE "nickname" = 'Vikings'