How many positions have an against of less than 27, and a played number of less than 8?
CREATE TABLE table_name_59 (position VARCHAR, against VARCHAR, played VARCHAR)
SELECT COUNT(position) FROM table_name_59 WHERE against < 27 AND played < 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (position VARCHAR, against VARCHAR, played VARCHAR) Question: How many positions have an against of less than 27, and a played number of less than 8? [/INST] SELECT COUNT(position) FROM table_name_59 WHERE against < 27 AND played < 8 </s>