Table: draft_pick_25
Columns: round
pick
player
position
college

Question: What's the average draft pick number from Carson-Newman College before Round 7?
SQL: SELECT AVG("pick") FROM draft_pick_25 WHERE "college" = 'carson-newman' AND "round" < 7

Question: Which college has a pick number of 155?
SQL: SELECT "college" FROM draft_pick_25 WHERE "pick" = 155