Which Pick # is the highest and has the Rd # is under 1?
CREATE TABLE table_name_9 (pick__number INTEGER, rd__number INTEGER)
SELECT MAX(pick__number) FROM table_name_9 WHERE rd__number < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (pick__number INTEGER, rd__number INTEGER) Question: Which Pick # is the highest and has the Rd # is under 1? [/INST] SELECT MAX(pick__number) FROM table_name_9 WHERE rd__number < 1 </s>