What is the highest Pick, when College is "Syracuse", and when Overall is less than 18?
CREATE TABLE table_name_40 (pick INTEGER, college VARCHAR, overall VARCHAR)
SELECT MAX(pick) FROM table_name_40 WHERE college = "syracuse" AND overall < 18
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (pick INTEGER, college VARCHAR, overall VARCHAR) Question: What is the highest Pick, when College is "Syracuse", and when Overall is less than 18? [/INST] SELECT MAX(pick) FROM table_name_40 WHERE college = "syracuse" AND overall < 18 </s>