Table: draft_history_19
Columns: round
pick
overall
name
position
college

Question: Which Overall is the average one that has a Pick # larger than 7, and a Round larger than 4, and a Name of glen howe?
SQL: SELECT AVG("overall") FROM draft_history_19 WHERE "pick" > 7 AND "round" > 4 AND "name" = 'glen howe'

Question: Which Round is the lowest one that has a Pick # larger than 10, and a Position of tight end, and an Overall smaller than 132?
SQL: SELECT MIN("round") FROM draft_history_19 WHERE "pick" > 10 AND "position" = 'tight end' AND "overall" < 132

Question: Which Round is the highest one that has an Overall of 32, and a Pick # smaller than 4?
SQL: SELECT MAX("round") FROM draft_history_19 WHERE "overall" = 32 AND "pick" < 4

Question: How many Picks have a Round larger than 8, and a College of fresno state?
SQL: SELECT COUNT("pick") FROM draft_history_19 WHERE "round" > 8 AND "college" = 'fresno state'

Question: Which Overall is the highest one that has a College of oklahoma, and a Pick # smaller than 4?
SQL: SELECT MAX("overall") FROM draft_history_19 WHERE "college" = 'oklahoma' AND "pick" < 4