What's the highest number of silver for 9 bronze and less than 27 total?
CREATE TABLE table_name_43 (silver INTEGER, bronze VARCHAR, total VARCHAR)
SELECT MAX(silver) FROM table_name_43 WHERE bronze = 9 AND total < 27
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (silver INTEGER, bronze VARCHAR, total VARCHAR) Question: What's the highest number of silver for 9 bronze and less than 27 total? [/INST] SELECT MAX(silver) FROM table_name_43 WHERE bronze = 9 AND total < 27 </s>