What is the average Year, when Country is "U.S.", and when Location is "Edmond , OK"?
CREATE TABLE table_name_28 (year INTEGER, country VARCHAR, location VARCHAR)
SELECT AVG(year) FROM table_name_28 WHERE country = "u.s." AND location = "edmond , ok"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_28 (year INTEGER, country VARCHAR, location VARCHAR) Question: What is the average Year, when Country is "U.S.", and when Location is "Edmond , OK"? [/INST] SELECT AVG(year) FROM table_name_28 WHERE country = "u.s." AND location = "edmond , ok" </s>