user: ### NOW ANSWER:
Question: Which Overall is the highest one that has a Pick # smaller than 9, and a Name of Mike Pearson?
Columns: ['Round', 'Pick #', 'Overall', 'Name', 'Position', 'College']
Types: ['real', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 9.0, 9.0, 'John Henderson', 'Defensive Tackle', 'Tennessee']
SQL:

assistant: SELECT MAX("Overall") FROM "Table" WHERE "Pick #" < 9.0 AND "Name" = 'Mike Pearson';