CREATE TABLE table_name_69 (overall INT, round VARCHAR, pick VARCHAR, college VARCHAR)

What is the average overall that has a pick less than 20, North Carolina as the college, with a round less than 8?
SELECT AVG(overall) FROM table_name_69 WHERE pick < 20 AND college = "north carolina" AND round < 8
SELECT AVG("overall") FROM "table_name_69" WHERE "college" = "north carolina" AND "pick" < 20 AND "round" < 8