For the United States, with greater than 2 bronze metals, greater than 3 silver medals, and a rank higher than 3, what is the highest total number of medals?
CREATE TABLE table_name_4 (total INTEGER, silver VARCHAR, nation VARCHAR, bronze VARCHAR, rank VARCHAR)
SELECT MAX(total) FROM table_name_4 WHERE bronze > 2 AND rank > 3 AND nation = "united states" AND silver > 3
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (total INTEGER, silver VARCHAR, nation VARCHAR, bronze VARCHAR, rank VARCHAR) Question: For the United States, with greater than 2 bronze metals, greater than 3 silver medals, and a rank higher than 3, what is the highest total number of medals? [/INST] SELECT MAX(total) FROM table_name_4 WHERE bronze > 2 AND rank > 3 AND nation = "united states" AND silver > 3 </s>