What is the average number of points for a difference of 55 and an against less than 47?
CREATE TABLE table_name_99 (points INTEGER, difference VARCHAR, against VARCHAR)
SELECT AVG(points) FROM table_name_99 WHERE difference = "55" AND against < 47
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (points INTEGER, difference VARCHAR, against VARCHAR) Question: What is the average number of points for a difference of 55 and an against less than 47? [/INST] SELECT AVG(points) FROM table_name_99 WHERE difference = "55" AND against < 47 </s>