Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: 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?

### Accurate SQL ###

SELECT ihsaa_football_class FROM table_name_79 WHERE ihsaa_class = "aaa" AND location = "nashville"