What is the average rec that is greater than 10 and has 40 yards?
CREATE TABLE table_name_2 (rec INTEGER, yards VARCHAR, avg VARCHAR)
SELECT AVG(rec) FROM table_name_2 WHERE yards = 40 AND avg > 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (rec INTEGER, yards VARCHAR, avg VARCHAR) Question: What is the average rec that is greater than 10 and has 40 yards? [/INST] SELECT AVG(rec) FROM table_name_2 WHERE yards = 40 AND avg > 10 </s>