I want the total number of matches for draw less than 7 and lost point of 16 with lose more than 4
CREATE TABLE table_name_14 (matches VARCHAR, lose VARCHAR, draw VARCHAR, lost_point VARCHAR)
SELECT COUNT(matches) FROM table_name_14 WHERE draw < 7 AND lost_point = 16 AND lose > 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_14 (matches VARCHAR, lose VARCHAR, draw VARCHAR, lost_point VARCHAR) Question: I want the total number of matches for draw less than 7 and lost point of 16 with lose more than 4 [/INST] SELECT COUNT(matches) FROM table_name_14 WHERE draw < 7 AND lost_point = 16 AND lose > 4 </s>