Which country has the most bronze and has more than one silver, 1 gold, and less than 4 total medals.
CREATE TABLE table_name_80 (bronze INTEGER, total VARCHAR, silver VARCHAR, gold VARCHAR)
SELECT MAX(bronze) FROM table_name_80 WHERE silver > 1 AND gold = 1 AND total < 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_80 (bronze INTEGER, total VARCHAR, silver VARCHAR, gold VARCHAR) Question: Which country has the most bronze and has more than one silver, 1 gold, and less than 4 total medals. [/INST] SELECT MAX(bronze) FROM table_name_80 WHERE silver > 1 AND gold = 1 AND total < 4 </s>