What is the total number of bronze that has less than 2 gold, and more than 1 silver?
CREATE TABLE table_name_97 (bronze VARCHAR, gold VARCHAR, silver VARCHAR)
SELECT COUNT(bronze) FROM table_name_97 WHERE gold < 2 AND silver > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (bronze VARCHAR, gold VARCHAR, silver VARCHAR) Question: What is the total number of bronze that has less than 2 gold, and more than 1 silver? [/INST] SELECT COUNT(bronze) FROM table_name_97 WHERE gold < 2 AND silver > 1 </s>