How many gold medals for the school with less than 1 total?
CREATE TABLE table_name_43 (gold_medals VARCHAR, total_medals INTEGER)
SELECT COUNT(gold_medals) FROM table_name_43 WHERE total_medals < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (gold_medals VARCHAR, total_medals INTEGER) Question: How many gold medals for the school with less than 1 total? [/INST] SELECT COUNT(gold_medals) FROM table_name_43 WHERE total_medals < 1 </s>