How many Played have a Lost smaller than 3, and a Difference of 6, and Points larger than 6?
CREATE TABLE table_name_99 (played VARCHAR, points VARCHAR, lost VARCHAR, difference VARCHAR)
SELECT COUNT(played) FROM table_name_99 WHERE lost < 3 AND difference = "6" AND points > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (played VARCHAR, points VARCHAR, lost VARCHAR, difference VARCHAR) Question: How many Played have a Lost smaller than 3, and a Difference of 6, and Points larger than 6? [/INST] SELECT COUNT(played) FROM table_name_99 WHERE lost < 3 AND difference = "6" AND points > 6 </s>