Table: draft_history_40
Columns: round
pick
overall
name
position
college

Question: Which Round is the highest one that has a College of arizona, and an Overall larger than 120?
SQL: SELECT MAX("round") FROM draft_history_40 WHERE "college" = 'arizona' AND "overall" > 120

Question: Which Pick has a Name of ed hickerson, and a Round smaller than 10?
SQL: SELECT SUM("pick") FROM draft_history_40 WHERE "name" = 'ed hickerson' AND "round" < 10

Question: How much Overall has a Pick of 10, and a Round smaller than 8, and a Position of e, and a College of tennessee?
SQL: SELECT COUNT("overall") FROM draft_history_40 WHERE "pick" = 10 AND "round" < 8 AND "position" = 'e' AND "college" = 'tennessee'