what is the year when the location is yankee stadium and the result is 23-23
CREATE TABLE table_name_74 (year INTEGER, location VARCHAR, result VARCHAR)
SELECT AVG(year) FROM table_name_74 WHERE location = "yankee stadium" AND result = "23-23"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (year INTEGER, location VARCHAR, result VARCHAR) Question: what is the year when the location is yankee stadium and the result is 23-23 [/INST] SELECT AVG(year) FROM table_name_74 WHERE location = "yankee stadium" AND result = "23-23" </s>