human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Round, Pick, Overall, Name, Position, College
###Question: What is the overall pick number for a draft pick smaller than 9, named buck mystrom from Michigan State college?
gpt
SELECT Overall FROM table WHERE Pick < 9 AND College = michigan state AND Name = buck mystrom