Table: draft_history_6
Columns: round
pick
overall
name
position
college

Question: Which Overall has a Name of bob anderson, and a Round smaller than 9?
SQL: SELECT AVG("overall") FROM draft_history_6 WHERE "name" = 'bob anderson' AND "round" < 9

Question: What is stanford's average overall?
SQL: SELECT AVG("overall") FROM draft_history_6 WHERE "college" = 'stanford'

Question: Which pick has a Round smaller than 8, and an Overall smaller than 16, and a Name of harry gilmer?
SQL: SELECT "pick" FROM draft_history_6 WHERE "round" < 8 AND "overall" < 16 AND "name" = 'harry gilmer'

Question: How much Overall has a Name of bob anderson?
SQL: SELECT COUNT("overall") FROM draft_history_6 WHERE "name" = 'bob anderson'