What is the highest rank of the medal total less than 15, more than 2 bronzes, 0 gold and 1 silver?
CREATE TABLE table_name_29 (rank INTEGER, silver VARCHAR, gold VARCHAR, total VARCHAR, bronze VARCHAR)
SELECT MAX(rank) FROM table_name_29 WHERE total < 15 AND bronze > 2 AND gold = 0 AND silver = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (rank INTEGER, silver VARCHAR, gold VARCHAR, total VARCHAR, bronze VARCHAR) Question: What is the highest rank of the medal total less than 15, more than 2 bronzes, 0 gold and 1 silver? [/INST] SELECT MAX(rank) FROM table_name_29 WHERE total < 15 AND bronze > 2 AND gold = 0 AND silver = 1 </s>