Table: draft_history_24
Columns: round
pick
overall
name
position
college

Question: Which Round has a College of stanford, and an Overall smaller than 8?
SQL: SELECT AVG("round") FROM draft_history_24 WHERE "college" = 'stanford' AND "overall" < 8

Question: How many Picks have a College of tennessee, and an Overall smaller than 270?
SQL: SELECT SUM("pick") FROM draft_history_24 WHERE "college" = 'tennessee' AND "overall" < 270

Question: Which Pick # is the lowest one that has a College of troy state, and a Name of reggie dwight, and an Overall smaller than 217?
SQL: SELECT MIN("pick") FROM draft_history_24 WHERE "college" = 'troy state' AND "name" = 'reggie dwight' AND "overall" < 217