How many Againsts have Points larger than 31 and a Drawn larger than 6?
CREATE TABLE table_name_96 (against VARCHAR, points VARCHAR, drawn VARCHAR)
SELECT COUNT(against) FROM table_name_96 WHERE points > 31 AND drawn > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (against VARCHAR, points VARCHAR, drawn VARCHAR) Question: How many Againsts have Points larger than 31 and a Drawn larger than 6? [/INST] SELECT COUNT(against) FROM table_name_96 WHERE points > 31 AND drawn > 6 </s>