What is the lowest Against, when Status is "First Test", and when Date is "26/05/2007"?
CREATE TABLE table_name_42 (against INTEGER, status VARCHAR, date VARCHAR)
SELECT MIN(against) FROM table_name_42 WHERE status = "first test" AND date = "26/05/2007"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (against INTEGER, status VARCHAR, date VARCHAR) Question: What is the lowest Against, when Status is "First Test", and when Date is "26/05/2007"? [/INST] SELECT MIN(against) FROM table_name_42 WHERE status = "first test" AND date = "26/05/2007" </s>