CREATE TABLE table_name_47 (overall NUMBER, pick__number VARCHAR2, position VARCHAR2, round VARCHAR2)

Position of defensive tackle, and a Round of 4, and a Pick # smaller than 36 has what overall average?
SELECT AVG(overall) FROM table_name_47 WHERE position = "defensive tackle" AND round = 4 AND pick__number < 36
SELECT AVG("overall") FROM "table_name_47" WHERE "defensive tackle" = "position" AND "pick__number" < 36 AND "round" = 4