CREATE TABLE table_name_79 (ihsaa_football_class VARCHAR2, ihsaa_class VARCHAR2, location VARCHAR2)

Which IHSAA Football Class has a IHSAA Class of aaa, and a Location of nashville?
SELECT ihsaa_football_class FROM table_name_79 WHERE ihsaa_class = "aaa" AND location = "nashville"
SELECT "ihsaa_football_class" FROM "table_name_79" WHERE "aaa" = "ihsaa_class" AND "location" = "nashville"