What is the highest rank when the metal total is 1 and the nation is the United Kingdom?
CREATE TABLE table_name_99 (rank INTEGER, total VARCHAR, nation VARCHAR)
SELECT MAX(rank) FROM table_name_99 WHERE total = 1 AND nation = "united kingdom"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (rank INTEGER, total VARCHAR, nation VARCHAR) Question: What is the highest rank when the metal total is 1 and the nation is the United Kingdom? [/INST] SELECT MAX(rank) FROM table_name_99 WHERE total = 1 AND nation = "united kingdom" </s>