Table: draft_history_7
Columns: round
pick
overall
name
position
college

Question: What is the total number of overall picks that were after pick 9 and went to Auburn College?
SQL: SELECT COUNT("overall") FROM draft_history_7 WHERE "college" = 'auburn' AND "pick" > 9

Question: What is the overall pick number for a draft pick smaller than 9, named buck mystrom from Michigan State college?
SQL: SELECT "overall" FROM draft_history_7 WHERE "pick" < 9 AND "college" = 'michigan state' AND "name" = 'buck mystrom'

Question: What is the average number of rounds for billy hicks who had an overall pick number bigger than 310?
SQL: SELECT AVG("round") FROM draft_history_7 WHERE "overall" > 310 AND "name" = 'billy hicks'

Question: What is the sum of rounds that has a pick of 9 and is named jim pyburn?
SQL: SELECT SUM("round") FROM draft_history_7 WHERE "pick" = 9 AND "name" = 'jim pyburn'

Question: What is the highest round number for donnie caraway?
SQL: SELECT MAX("round") FROM draft_history_7 WHERE "name" = 'donnie caraway'

Question: What is the highest overall pick number for george nicula who had a pick smaller than 9?
SQL: SELECT MAX("overall") FROM draft_history_7 WHERE "name" = 'george nicula' AND "pick" < 9