How many times does Switzerland have under 7 golds and less than 3 silvers?
CREATE TABLE table_name_17 (total VARCHAR, silver VARCHAR, country VARCHAR, gold VARCHAR)
SELECT COUNT(total) FROM table_name_17 WHERE country = "switzerland" AND gold < 7 AND silver < 3
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (total VARCHAR, silver VARCHAR, country VARCHAR, gold VARCHAR) Question: How many times does Switzerland have under 7 golds and less than 3 silvers? [/INST] SELECT COUNT(total) FROM table_name_17 WHERE country = "switzerland" AND gold < 7 AND silver < 3 </s>