What's the average Year that has Points that's smaller than 9 with a Rank of 24th?
CREATE TABLE table_name_71 (year INTEGER, points VARCHAR, rank VARCHAR)
SELECT AVG(year) FROM table_name_71 WHERE points < 9 AND rank = "24th"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_71 (year INTEGER, points VARCHAR, rank VARCHAR) Question: What's the average Year that has Points that's smaller than 9 with a Rank of 24th? [/INST] SELECT AVG(year) FROM table_name_71 WHERE points < 9 AND rank = "24th" </s>