Which Pick # is the highest one that has a Name of william middleton, and a Round larger than 5?
CREATE TABLE table_name_32 (pick__number INTEGER, name VARCHAR, round VARCHAR)
SELECT MAX(pick__number) FROM table_name_32 WHERE name = "william middleton" AND round > 5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_32 (pick__number INTEGER, name VARCHAR, round VARCHAR) Question: Which Pick # is the highest one that has a Name of william middleton, and a Round larger than 5? [/INST] SELECT MAX(pick__number) FROM table_name_32 WHERE name = "william middleton" AND round > 5 </s>