Table: draft_history_6
Columns: round
pick
overall
name
position
college

Question: What's the Overall average that has brad scioli, and a Pick # larger than 5?
SQL: SELECT AVG("overall") FROM draft_history_6 WHERE "name" = 'brad scioli' AND "pick" > 5

Question: What's the lowest Overall average that has a College of Arkansas, and a Round larger than 3?
SQL: SELECT MIN("overall") FROM draft_history_6 WHERE "college" = 'arkansas' AND "round" > 3

Question: Which highest Overall has a Pick # of 4, and a Round larger than 7?
SQL: SELECT MAX("overall") FROM draft_history_6 WHERE "pick" = 4 AND "round" > 7

Question: What's the overall average that has a round less than 7, and a Pick # of 4?
SQL: SELECT AVG("overall") FROM draft_history_6 WHERE "round" < 7 AND "pick" = 4