How many gold have a National of New Zealand with a total less than 2?
CREATE TABLE table_name_15 (gold INTEGER, nation VARCHAR, total VARCHAR)
SELECT SUM(gold) FROM table_name_15 WHERE nation = "new zealand" AND total < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_15 (gold INTEGER, nation VARCHAR, total VARCHAR) Question: How many gold have a National of New Zealand with a total less than 2? [/INST] SELECT SUM(gold) FROM table_name_15 WHERE nation = "new zealand" AND total < 2 </s>