human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Round, Pick, Overall, Name, Position, College
###Question: What is the average overall that has a pick less than 20, North Carolina as the college, with a round less than 8?
gpt
SELECT AVG Overall FROM table WHERE Pick < 20 AND College = north carolina AND Round < 8