Tell me the least silver for total less than 6 and rank of 8
CREATE TABLE table_name_17 (silver INTEGER, total VARCHAR, rank VARCHAR)
SELECT MIN(silver) FROM table_name_17 WHERE total < 6 AND rank = "8"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (silver INTEGER, total VARCHAR, rank VARCHAR) Question: Tell me the least silver for total less than 6 and rank of 8 [/INST] SELECT MIN(silver) FROM table_name_17 WHERE total < 6 AND rank = "8" </s>