What is the average overall that has a pick less than 20, North Carolina as the college, with a round less than 8?
CREATE TABLE table_76922 (
    "Round" real,
    "Pick" real,
    "Overall" real,
    "Name" text,
    "Position" text,
    "College" text
)
SELECT AVG("Overall") FROM table_76922 WHERE "Pick" < '20' AND "College" = 'north carolina' AND "Round" < '8'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the average overall that has a pick less than 20, North Carolina as the college, with a round less than 8? ### Input: CREATE TABLE table_76922 (
    "Round" real,
    "Pick" real,
    "Overall" real,
    "Name" text,
    "Position" text,
    "College" text
) ### Response: SELECT AVG("Overall") FROM table_76922 WHERE "Pick" < '20' AND "College" = 'north carolina' AND "Round" < '8'