Table: draft_history_9
Columns: round
pick
overall
name
position
college

Question: Which college has a pick less than 25, an overall greater than 159, a round less than 10, and wr as the position?
SQL: SELECT "college" FROM draft_history_9 WHERE "pick" < 25 AND "overall" > 159 AND "round" < 10 AND "position" = 'wr'

Question: What is the average overall that has a pick less than 20, North Carolina as the college, with a round less than 8?
SQL: SELECT AVG("overall") FROM draft_history_9 WHERE "pick" < 20 AND "college" = 'north carolina' AND "round" < 8

Question: How many overalls have a pick greater than 19, with florida as the college?
SQL: SELECT SUM("overall") FROM draft_history_9 WHERE "pick" > 19 AND "college" = 'florida'

Question: What college has an overall less than 243, and tony green as the name?
SQL: SELECT "college" FROM draft_history_9 WHERE "overall" < 243 AND "name" = 'tony green'