When the United States had a total score of 274 what was the average year?
CREATE TABLE table_name_67 (year INTEGER, total_score VARCHAR, country VARCHAR)
SELECT AVG(year) FROM table_name_67 WHERE total_score = "274" AND country = "united states"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_67 (year INTEGER, total_score VARCHAR, country VARCHAR) Question: When the United States had a total score of 274 what was the average year? [/INST] SELECT AVG(year) FROM table_name_67 WHERE total_score = "274" AND country = "united states" </s>