What state is Knoxville and the mideast region located in?
CREATE TABLE table_name_76 (state VARCHAR, region VARCHAR, city VARCHAR)
SELECT state FROM table_name_76 WHERE region = "mideast" AND city = "knoxville"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (state VARCHAR, region VARCHAR, city VARCHAR) Question: What state is Knoxville and the mideast region located in? [/INST] SELECT state FROM table_name_76 WHERE region = "mideast" AND city = "knoxville" </s>