What is the average year that has a win less than 1, yamaha as the team, with points greater than 2?
CREATE TABLE table_name_30 (year INTEGER, points VARCHAR, wins VARCHAR, team VARCHAR)
SELECT AVG(year) FROM table_name_30 WHERE wins < 1 AND team = "yamaha" AND points > 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (year INTEGER, points VARCHAR, wins VARCHAR, team VARCHAR) Question: What is the average year that has a win less than 1, yamaha as the team, with points greater than 2? [/INST] SELECT AVG(year) FROM table_name_30 WHERE wins < 1 AND team = "yamaha" AND points > 2 </s>