Table: tar_heels_draft_2007
Columns: year
round
pick
player
nba_club

Question: What is the pick number later than round 1, for Reyshawn Terry?
SQL: SELECT AVG("pick") FROM tar_heels_draft_2007 WHERE "round" > 1 AND "player" = 'reyshawn terry'

Question: What round was the player Ty Lawson with a pick earlier than 18?
SQL: SELECT AVG("round") FROM tar_heels_draft_2007 WHERE "player" = 'ty lawson' AND "pick" < 18

Question: What is the pick number for Danny Green in a round less than 2?
SQL: SELECT COUNT("pick") FROM tar_heels_draft_2007 WHERE "player" = 'danny green' AND "round" < 2

Question: What is the pick number in a year earlier than 2009, with a round higher than 1?
SQL: SELECT COUNT("pick") FROM tar_heels_draft_2007 WHERE "year" < 2009 AND "round" > 1