user: ### NOW ANSWER:
Question: What's the average draft pick number from carson-newman College before Round 7?
Columns: ['Round', 'Pick #', 'Player', 'Position', 'College']
Types: ['real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 16.0, 'James Williams', 'Defensive back', 'Fresno State']
SQL:

assistant: SELECT AVG("Pick #") FROM "Table" WHERE "College" = 'carson-newman' AND "Round" < 7.0;