What is the highest Pick # for the College of Maryland-Eastern Shore?
CREATE TABLE table_name_97 (pick__number INTEGER, college VARCHAR)
SELECT MAX(pick__number) FROM table_name_97 WHERE college = "maryland-eastern shore"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (pick__number INTEGER, college VARCHAR) Question: What is the highest Pick # for the College of Maryland-Eastern Shore? [/INST] SELECT MAX(pick__number) FROM table_name_97 WHERE college = "maryland-eastern shore" </s>