What is the average Total, when the value for Silver is less than 1, when the value for Gold is 0, when the Nation is Switzerland, and when the value for Bronze is 2?
CREATE TABLE table_name_8 (total INTEGER, bronze VARCHAR, nation VARCHAR, silver VARCHAR, gold VARCHAR)
SELECT AVG(total) FROM table_name_8 WHERE silver < 1 AND gold = 0 AND nation = "switzerland" AND bronze < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (total INTEGER, bronze VARCHAR, nation VARCHAR, silver VARCHAR, gold VARCHAR) Question: What is the average Total, when the value for Silver is less than 1, when the value for Gold is 0, when the Nation is Switzerland, and when the value for Bronze is 2? [/INST] SELECT AVG(total) FROM table_name_8 WHERE silver < 1 AND gold = 0 AND nation = "switzerland" AND bronze < 2 </s>