Table schema:
CREATE TABLE table_1973842_2 (nickname VARCHAR, location VARCHAR)

Question: What's the nickname of the school in Maryville, Tennessee?
SQL: SELECT nickname FROM table_1973842_2 WHERE location = "Maryville, Tennessee"