What is the highest Pick, when Nationality is "United States", when College is "New Mexico State", and when Round is greater than 6?
CREATE TABLE table_name_35 (pick INTEGER, round VARCHAR, nationality VARCHAR, college VARCHAR)
SELECT MAX(pick) FROM table_name_35 WHERE nationality = "united states" AND college = "new mexico state" AND round > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_35 (pick INTEGER, round VARCHAR, nationality VARCHAR, college VARCHAR) Question: What is the highest Pick, when Nationality is "United States", when College is "New Mexico State", and when Round is greater than 6? [/INST] SELECT MAX(pick) FROM table_name_35 WHERE nationality = "united states" AND college = "new mexico state" AND round > 6 </s>