What is the highest metal total when there are 2 Gold medals, 0 Bronze metals, and the rank is smaller than 2?
CREATE TABLE table_name_24 (total INTEGER, rank VARCHAR, gold VARCHAR, bronze VARCHAR)
SELECT MAX(total) FROM table_name_24 WHERE gold = 2 AND bronze = 0 AND rank < 2
<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, bronze VARCHAR) Question: What is the highest metal total when there are 2 Gold medals, 0 Bronze metals, and the rank is smaller than 2? [/INST] SELECT MAX(total) FROM table_name_24 WHERE gold = 2 AND bronze = 0 AND rank < 2 </s>