Name the Year with a Rank-Final smaller than 2, an Apparatus of team, and a Score-Qualifying smaller than 248.275?
CREATE TABLE table_name_8 (year INTEGER, score_qualifying VARCHAR, rank_final VARCHAR, apparatus VARCHAR)
SELECT AVG(year) FROM table_name_8 WHERE rank_final < 2 AND apparatus = "team" AND score_qualifying < 248.275
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (year INTEGER, score_qualifying VARCHAR, rank_final VARCHAR, apparatus VARCHAR) Question: Name the Year with a Rank-Final smaller than 2, an Apparatus of team, and a Score-Qualifying smaller than 248.275? [/INST] SELECT AVG(year) FROM table_name_8 WHERE rank_final < 2 AND apparatus = "team" AND score_qualifying < 248.275 </s>