What is the mean number of played when there are less than 18 points and the position is less than 8?
CREATE TABLE table_name_45 (played INTEGER, points VARCHAR, position VARCHAR)
SELECT AVG(played) FROM table_name_45 WHERE points < 18 AND position < 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_45 (played INTEGER, points VARCHAR, position VARCHAR) Question: What is the mean number of played when there are less than 18 points and the position is less than 8? [/INST] SELECT AVG(played) FROM table_name_45 WHERE points < 18 AND position < 8 </s>