What is the highest number of Silvers for rank 7 teams with 1 gold and under 1 bronze?
CREATE TABLE table_name_37 (silver INTEGER, rank VARCHAR, bronze VARCHAR, gold VARCHAR)
SELECT MAX(silver) FROM table_name_37 WHERE bronze < 1 AND gold = 1 AND rank = "7"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_37 (silver INTEGER, rank VARCHAR, bronze VARCHAR, gold VARCHAR) Question: What is the highest number of Silvers for rank 7 teams with 1 gold and under 1 bronze? [/INST] SELECT MAX(silver) FROM table_name_37 WHERE bronze < 1 AND gold = 1 AND rank = "7" </s>