What is the average number of points when the ranking is 7th and the draw is less than 4?
CREATE TABLE table_name_63 (points INTEGER, rank VARCHAR, draw VARCHAR)
SELECT AVG(points) FROM table_name_63 WHERE rank = "7th" AND draw < 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_63 (points INTEGER, rank VARCHAR, draw VARCHAR) Question: What is the average number of points when the ranking is 7th and the draw is less than 4? [/INST] SELECT AVG(points) FROM table_name_63 WHERE rank = "7th" AND draw < 4 </s>