How many totals have 0 as Gold, a bronze greater than 1, and a silver less than 1?
CREATE TABLE table_name_94 (total VARCHAR, silver VARCHAR, gold VARCHAR, bronze VARCHAR)
SELECT COUNT(total) FROM table_name_94 WHERE gold = 0 AND bronze > 1 AND silver < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_94 (total VARCHAR, silver VARCHAR, gold VARCHAR, bronze VARCHAR) Question: How many totals have 0 as Gold, a bronze greater than 1, and a silver less than 1? [/INST] SELECT COUNT(total) FROM table_name_94 WHERE gold = 0 AND bronze > 1 AND silver < 1 </s>