CREATE TABLE table_name_76 (state VARCHAR2, region VARCHAR2, city VARCHAR2)

What state is Knoxville and the mideast region located in?
SELECT state FROM table_name_76 WHERE region = "mideast" AND city = "knoxville"
SELECT "state" FROM "table_name_76" WHERE "city" = "knoxville" AND "mideast" = "region"