Which IHSAA Football Class has a IHSAA Class of aaa, and a Location of nashville?
CREATE TABLE table_name_79 (ihsaa_football_class VARCHAR, ihsaa_class VARCHAR, location VARCHAR)
SELECT ihsaa_football_class FROM table_name_79 WHERE ihsaa_class = "aaa" AND location = "nashville"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_79 (ihsaa_football_class VARCHAR, ihsaa_class VARCHAR, location VARCHAR) Question: Which IHSAA Football Class has a IHSAA Class of aaa, and a Location of nashville? [/INST] SELECT ihsaa_football_class FROM table_name_79 WHERE ihsaa_class = "aaa" AND location = "nashville" </s>