What is the most number of Bronze medals won among the countries that have won more than 1 medal, more than 1 gold medal, and have a rank bigger than 1?
CREATE TABLE table_name_49 (bronze INTEGER, gold VARCHAR, total VARCHAR, rank VARCHAR)
SELECT MAX(bronze) FROM table_name_49 WHERE total > 1 AND rank > 1 AND gold > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_49 (bronze INTEGER, gold VARCHAR, total VARCHAR, rank VARCHAR) Question: What is the most number of Bronze medals won among the countries that have won more than 1 medal, more than 1 gold medal, and have a rank bigger than 1? [/INST] SELECT MAX(bronze) FROM table_name_49 WHERE total > 1 AND rank > 1 AND gold > 1 </s>