Table: derrick_harvey
Columns: round
pick
overall
name
position
college

Question: What is the overall pick number that Derrick Harvey was when he was picked in a round after round 1?
SQL: SELECT MIN("overall") FROM derrick_harvey WHERE "name" = 'derrick harvey' AND "round" > 1

Question: What college was the defensive end pick that was picked in round 2?
SQL: SELECT "college" FROM derrick_harvey WHERE "position" = 'defensive end' AND "round" = 2

Question: What is the average round that the player from USF was picked in when his draft pick number was less than 24?
SQL: SELECT AVG("round") FROM derrick_harvey WHERE "college" = 'usf' AND "pick" < 24

Question: What is the sum of the pick numbers where the player was picked in round 5 and overall pick number was greater than 159?
SQL: SELECT SUM("pick") FROM derrick_harvey WHERE "round" = 5 AND "overall" > 159

Question: What is the average overall pick number for the USF player who was picked after round 5?
SQL: SELECT AVG("overall") FROM derrick_harvey WHERE "college" = 'usf' AND "round" > 5