I want the lowest points diff for against being less than 578 and lost being 15 and points more than 26
CREATE TABLE table_name_37 (points_diff INTEGER, points VARCHAR, against VARCHAR, lost VARCHAR)
SELECT MIN(points_diff) FROM table_name_37 WHERE against < 578 AND lost = 15 AND points > 26
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_37 (points_diff INTEGER, points VARCHAR, against VARCHAR, lost VARCHAR) Question: I want the lowest points diff for against being less than 578 and lost being 15 and points more than 26 [/INST] SELECT MIN(points_diff) FROM table_name_37 WHERE against < 578 AND lost = 15 AND points > 26 </s>