What is the total rank with more than 0 silver and less than 2 medals total?
CREATE TABLE table_name_88 (rank VARCHAR, total VARCHAR, silver VARCHAR)
SELECT COUNT(rank) FROM table_name_88 WHERE total < 2 AND silver > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_88 (rank VARCHAR, total VARCHAR, silver VARCHAR) Question: What is the total rank with more than 0 silver and less than 2 medals total? [/INST] SELECT COUNT(rank) FROM table_name_88 WHERE total < 2 AND silver > 0 </s>