How many total draws were there with a less than 8 loss, more than 30 points, and a goal diff larger than 26?
CREATE TABLE table_name_21 (draw VARCHAR, goal_diff VARCHAR, loss VARCHAR, point VARCHAR)
SELECT COUNT(draw) FROM table_name_21 WHERE loss < 8 AND point > 30 AND goal_diff > 26
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (draw VARCHAR, goal_diff VARCHAR, loss VARCHAR, point VARCHAR) Question: How many total draws were there with a less than 8 loss, more than 30 points, and a goal diff larger than 26? [/INST] SELECT COUNT(draw) FROM table_name_21 WHERE loss < 8 AND point > 30 AND goal_diff > 26 </s>