Which Oilers points have a Record of 10–6, and Oilers first downs larger than 14?
CREATE TABLE table_name_1 (oilers_points INTEGER, record VARCHAR, oilers_first_downs VARCHAR)
SELECT AVG(oilers_points) FROM table_name_1 WHERE record = "10–6" AND oilers_first_downs > 14
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (oilers_points INTEGER, record VARCHAR, oilers_first_downs VARCHAR) Question: Which Oilers points have a Record of 10–6, and Oilers first downs larger than 14? [/INST] SELECT AVG(oilers_points) FROM table_name_1 WHERE record = "10–6" AND oilers_first_downs > 14 </s>