Table: draft_history_36
Columns: round
pick
overall
name
position
college

Question: What is the total number of overall figures when duke was the college and the round was higher than 7?
SQL: SELECT SUM("overall") FROM draft_history_36 WHERE "college" = 'duke' AND "round" > 7

Question: Which of the highest pick numbers had a round of less than 2?
SQL: SELECT MAX("pick") FROM draft_history_36 WHERE "round" < 2

Question: Which pick number had a round of less than 7, an overall of less than 127, and where the name was Robert Alford?
SQL: SELECT "pick" FROM draft_history_36 WHERE "round" < 7 AND "overall" < 127 AND "name" = 'robert alford'

Question: Which highest overall figure had Robert Alford as a name and a round of more than 2?
SQL: SELECT MAX("overall") FROM draft_history_36 WHERE "name" = 'robert alford' AND "round" > 2