WHAT IS THE HIGHEST PICK WITH A TE POSITION, AND ROUND SMALLER THAN 2?
CREATE TABLE table_name_11 (pick INTEGER, position VARCHAR, round VARCHAR)
SELECT MAX(pick) FROM table_name_11 WHERE position = "te" AND round < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_11 (pick INTEGER, position VARCHAR, round VARCHAR) Question: WHAT IS THE HIGHEST PICK WITH A TE POSITION, AND ROUND SMALLER THAN 2? [/INST] SELECT MAX(pick) FROM table_name_11 WHERE position = "te" AND round < 2 </s>