What is the average 2006 value for wheat with a 2005 value greater than 7340?
CREATE TABLE table_name_47 (production_year VARCHAR)
SELECT AVG(2006) FROM table_name_47 WHERE production_year = "wheat" AND 2005 > 7340
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (production_year VARCHAR) Question: What is the average 2006 value for wheat with a 2005 value greater than 7340? [/INST] SELECT AVG(2006) FROM table_name_47 WHERE production_year = "wheat" AND 2005 > 7340 </s>