Table: school_info
Columns: school
location
founded
affiliation
mascot
division

Question: What are the locations with a panthers mascot?
SQL: SELECT "location" FROM school_info WHERE "mascot" = 'Panthers'

Question: What are the locations with an eagles macot?
SQL: SELECT "location" FROM school_info WHERE "mascot" = 'Eagles'

Question: How many teams have an eagles mascot?
SQL: SELECT COUNT("affiliation") FROM school_info WHERE "mascot" = 'Eagles'

Question: How many teams have the titans as a mascot?
SQL: SELECT COUNT("affiliation") FROM school_info WHERE "mascot" = 'Titans'

Question: WHat year was north college hill high school founded?
SQL: SELECT MAX("founded") FROM school_info WHERE "school" = 'North College Hill High School'