What was the highest number of bronze medals when there were a total of 4 medals, 1 silver medals, and less than 2 medals?
CREATE TABLE table_name_99 (bronze INTEGER, gold VARCHAR, total VARCHAR, silver VARCHAR)
SELECT MAX(bronze) FROM table_name_99 WHERE total = 4 AND silver = 1 AND gold < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (bronze INTEGER, gold VARCHAR, total VARCHAR, silver VARCHAR) Question: What was the highest number of bronze medals when there were a total of 4 medals, 1 silver medals, and less than 2 medals? [/INST] SELECT MAX(bronze) FROM table_name_99 WHERE total = 4 AND silver = 1 AND gold < 2 </s>