Which Played has a Points of 2, and a Position smaller than 8?
CREATE TABLE table_name_28 (played INTEGER, points VARCHAR, position VARCHAR)
SELECT AVG(played) FROM table_name_28 WHERE points = 2 AND position < 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_28 (played INTEGER, points VARCHAR, position VARCHAR) Question: Which Played has a Points of 2, and a Position smaller than 8? [/INST] SELECT AVG(played) FROM table_name_28 WHERE points = 2 AND position < 8 </s>