CREATE TABLE table_name_30 (pick INT, player VARCHAR, round VARCHAR)

What was the highest Pick for Lonnie Brockman before round 9?
SELECT MAX(pick) FROM table_name_30 WHERE player = "lonnie brockman" AND round < 9
SELECT MAX("pick") FROM "table_name_30" WHERE "lonnie brockman" = "player" AND "round" < 9