CREATE TABLE table_name_21 (pick__number INT, college VARCHAR, round VARCHAR)

What's the average draft pick number from Carson-Newman College before Round 7?
SELECT AVG(pick__number) FROM table_name_21 WHERE college = "carson-newman" AND round < 7
SELECT AVG("pick__number") FROM "table_name_21" WHERE "carson-newman" = "college" AND "round" < 7