What is the lowest value of a team with revenue less than 374 and a debt of 84%?
CREATE TABLE table_name_26 (value__ INTEGER, revenue__$m_ VARCHAR, debt_as__percentageof_value VARCHAR)
SELECT MIN(value__) AS $m_ FROM table_name_26 WHERE revenue__$m_ < 374 AND debt_as__percentageof_value = "84"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (value__ INTEGER, revenue__$m_ VARCHAR, debt_as__percentageof_value VARCHAR) Question: What is the lowest value of a team with revenue less than 374 and a debt of 84%? [/INST] SELECT MIN(value__) AS $m_ FROM table_name_26 WHERE revenue__$m_ < 374 AND debt_as__percentageof_value = "84" </s>