Which Points have a Record of 12–2–4–1, and a November larger than 22?
CREATE TABLE table_name_40 (points INTEGER, record VARCHAR, november VARCHAR)
SELECT AVG(points) FROM table_name_40 WHERE record = "12–2–4–1" AND november > 22
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (points INTEGER, record VARCHAR, november VARCHAR) Question: Which Points have a Record of 12–2–4–1, and a November larger than 22? [/INST] SELECT AVG(points) FROM table_name_40 WHERE record = "12–2–4–1" AND november > 22 </s>