What is the lowest number of Gold, when the number of Bronze is less than 36, when the Rank is 2, and when Silver is less than 37?
CREATE TABLE table_name_97 (gold INTEGER, silver VARCHAR, bronze VARCHAR, rank VARCHAR)
SELECT MIN(gold) FROM table_name_97 WHERE bronze < 36 AND rank = "2" AND silver < 37
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (gold INTEGER, silver VARCHAR, bronze VARCHAR, rank VARCHAR) Question: What is the lowest number of Gold, when the number of Bronze is less than 36, when the Rank is 2, and when Silver is less than 37? [/INST] SELECT MIN(gold) FROM table_name_97 WHERE bronze < 36 AND rank = "2" AND silver < 37 </s>