Table: will_allen
Columns: round
pick
player
position
school

Question: What was the average round for john markham draft pick?
SQL: SELECT AVG("round") FROM will_allen WHERE "player" = 'john markham'

Question: What school did draft pick before 125, will allen go to?
SQL: SELECT "school" FROM will_allen WHERE "pick" < 125 AND "player" = 'will allen'

Question: What school did draft pick from round 3 go to?
SQL: SELECT "school" FROM will_allen WHERE "round" = 3