CREATE TABLE table_name_40 (pick__number NUMBER, round VARCHAR2, college VARCHAR2)

What is the pick number average for the player who was drafted before round 7, and went to college at Tennessee?
SELECT AVG(pick__number) FROM table_name_40 WHERE round < 7 AND college = "tennessee"
SELECT AVG("pick__number") FROM "table_name_40" WHERE "college" = "tennessee" AND "round" < 7