user: ### NOW ANSWER:
Question: What is Central Michigan's average overall when the pick was 8?
Columns: ['Round', 'Pick', 'Overall', 'Name', 'Position', 'College']
Types: ['real', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 9.0, 9.0, 'Don Bosseler', 'FB', 'Miami (FL)']
SQL:

assistant: SELECT AVG("Overall") FROM "Table" WHERE "College" = 'Central Michigan' AND "Pick" = 8.0;