Table: adam_nicolson_2007_pick
Columns: round
pick
player
position
school_club_team

Question: Which School/Club Team does Andrew Jones play for?
SQL: SELECT "school_club_team" FROM adam_nicolson_2007_pick WHERE "player" = 'andrew jones'

Question: Which School/Club Team did not make it to round 2?
SQL: SELECT "school_club_team" FROM adam_nicolson_2007_pick WHERE "round" < 2

Question: Which player is the 24 pick?
SQL: SELECT "player" FROM adam_nicolson_2007_pick WHERE "pick" = '24'

Question: What is the average round of the number 16 pick?
SQL: SELECT AVG("round") FROM adam_nicolson_2007_pick WHERE "pick" = '16'