Table: high_school_conferences_8
Columns: school
location
mascot
enrollment
ihsaa_class
ihsaa_football_class
county

Question: What school has an  IHSAA Class of aaa, and their mascot is Tiger Cubs?
SQL: SELECT "school" FROM high_school_conferences_8 WHERE "ihsaa_class" = 'aaa' AND "mascot" = 'tiger cubs'

Question: What is the IHSAA Football Class for county 67 putnam at Greencastle?
SQL: SELECT "ihsaa_football_class" FROM high_school_conferences_8 WHERE "county" = '67 putnam' AND "school" = 'greencastle'

Question: What school has more than 533 enrolled and is an IHSAA Football Class of aa?
SQL: SELECT "school" FROM high_school_conferences_8 WHERE "enrollment" > 533 AND "ihsaa_football_class" = 'aa'

Question: Where is the IHSAA Class of aaa school with more than 590 enrolled?
SQL: SELECT "location" FROM high_school_conferences_8 WHERE "ihsaa_class" = 'aaa' AND "enrollment" > 590