What was the highest Pick for Lonnie Brockman before round 9?
CREATE TABLE table_name_30 (pick INTEGER, player VARCHAR, round VARCHAR)
SELECT MAX(pick) FROM table_name_30 WHERE player = "lonnie brockman" AND round < 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (pick INTEGER, player VARCHAR, round VARCHAR) Question: What was the highest Pick for Lonnie Brockman before round 9? [/INST] SELECT MAX(pick) FROM table_name_30 WHERE player = "lonnie brockman" AND round < 9 </s>