CREATE TABLE table_76922 ("Round" FLOAT, "Pick" FLOAT, "Overall" FLOAT, "Name" CLOB, "Position" CLOB, "College" CLOB)

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_76922 WHERE "Pick" < '20' AND "College" = 'north carolina' AND "Round" < '8'
SELECT AVG("Overall") FROM "table_76922" WHERE "College" = 'north carolina' AND "Pick" < '20' AND "Round" < '8'