Which of the largest ranks has a bronze number less than 1, a silver of 1, and a total that is more than 1?
CREATE TABLE table_name_37 (rank INTEGER, total VARCHAR, bronze VARCHAR, silver VARCHAR)
SELECT MAX(rank) FROM table_name_37 WHERE bronze < 1 AND silver = 1 AND total > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_37 (rank INTEGER, total VARCHAR, bronze VARCHAR, silver VARCHAR) Question: Which of the largest ranks has a bronze number less than 1, a silver of 1, and a total that is more than 1? [/INST] SELECT MAX(rank) FROM table_name_37 WHERE bronze < 1 AND silver = 1 AND total > 1 </s>