With a silver greater than 0, gold of 9 and a bronze less than 9, what is the lowest total listed?
CREATE TABLE table_name_75 (total INTEGER, bronze VARCHAR, silver VARCHAR, gold VARCHAR)
SELECT MIN(total) FROM table_name_75 WHERE silver > 0 AND gold = 9 AND bronze < 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (total INTEGER, bronze VARCHAR, silver VARCHAR, gold VARCHAR) Question: With a silver greater than 0, gold of 9 and a bronze less than 9, what is the lowest total listed? [/INST] SELECT MIN(total) FROM table_name_75 WHERE silver > 0 AND gold = 9 AND bronze < 9 </s>