When the Total is less than 1, and Bronze is 0, how many Gold medals are there?
CREATE TABLE table_name_73 (gold INTEGER, bronze VARCHAR, total VARCHAR)
SELECT SUM(gold) FROM table_name_73 WHERE bronze = 0 AND total < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_73 (gold INTEGER, bronze VARCHAR, total VARCHAR) Question: When the Total is less than 1, and Bronze is 0, how many Gold medals are there? [/INST] SELECT SUM(gold) FROM table_name_73 WHERE bronze = 0 AND total < 1 </s>