CREATE TABLE table_1973842_2 (location VARCHAR, nickname VARCHAR)

Where is the school with nickname Tigers located?
SELECT location FROM table_1973842_2 WHERE nickname = "Tigers"
SELECT "location" FROM "table_1973842_2" WHERE "Tigers" = "nickname"