What is the lowest against value with less than 9 points and more than 6 lost?
CREATE TABLE table_name_29 (against INTEGER, points VARCHAR, lost VARCHAR)
SELECT MIN(against) FROM table_name_29 WHERE points < 9 AND lost > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (against INTEGER, points VARCHAR, lost VARCHAR) Question: What is the lowest against value with less than 9 points and more than 6 lost? [/INST] SELECT MIN(against) FROM table_name_29 WHERE points < 9 AND lost > 6 </s>