What is the lowest metal total when the Bronze metals are larger than 0, the Gold medals are smaller than 1, and the nation is Switzerland?
CREATE TABLE table_name_18 (total INTEGER, gold VARCHAR, bronze VARCHAR, nation VARCHAR)
SELECT MIN(total) FROM table_name_18 WHERE bronze > 0 AND nation = "switzerland" AND gold < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (total INTEGER, gold VARCHAR, bronze VARCHAR, nation VARCHAR) Question: What is the lowest metal total when the Bronze metals are larger than 0, the Gold medals are smaller than 1, and the nation is Switzerland? [/INST] SELECT MIN(total) FROM table_name_18 WHERE bronze > 0 AND nation = "switzerland" AND gold < 1 </s>