What is the total value for Lost, when the value for Points is greater than 21, and when the value for Draw is 2?
CREATE TABLE table_name_10 (lost INTEGER, points VARCHAR, draw VARCHAR)
SELECT SUM(lost) FROM table_name_10 WHERE points > 21 AND draw = 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_10 (lost INTEGER, points VARCHAR, draw VARCHAR) Question: What is the total value for Lost, when the value for Points is greater than 21, and when the value for Draw is 2? [/INST] SELECT SUM(lost) FROM table_name_10 WHERE points > 21 AND draw = 2 </s>