Which Total is the highest one that has a Rank of 1, and a Gold larger than 11?
CREATE TABLE table_name_24 (total INTEGER, rank VARCHAR, gold VARCHAR)
SELECT MAX(total) FROM table_name_24 WHERE rank = "1" AND gold > 11
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_24 (total INTEGER, rank VARCHAR, gold VARCHAR) Question: Which Total is the highest one that has a Rank of 1, and a Gold larger than 11? [/INST] SELECT MAX(total) FROM table_name_24 WHERE rank = "1" AND gold > 11 </s>