CREATE TABLE table_name_4 (overall INT, position VARCHAR, round VARCHAR)

What was the overall pick for the player who was a guard and had a round less than 9?
SELECT AVG(overall) FROM table_name_4 WHERE position = "guard" AND round < 9
SELECT AVG("overall") FROM "table_name_4" WHERE "guard" = "position" AND "round" < 9