What is the least number of gold medals won among nations ranked 1 with no silver medals?
CREATE TABLE table_name_8 (gold INTEGER, rank VARCHAR, silver VARCHAR)
SELECT MIN(gold) FROM table_name_8 WHERE rank = 1 AND silver < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (gold INTEGER, rank VARCHAR, silver VARCHAR) Question: What is the least number of gold medals won among nations ranked 1 with no silver medals? [/INST] SELECT MIN(gold) FROM table_name_8 WHERE rank = 1 AND silver < 1 </s>