CREATE TABLE table_name_76 (pick NUMBER, draft VARCHAR2, player VARCHAR2, round VARCHAR2, nationality VARCHAR2)

What is the average pick of player josh green from Canada from round 2 with a draft after 1996?
SELECT AVG(pick) FROM table_name_76 WHERE round = "2" AND nationality = "canada" AND player = "josh green" AND draft > 1996
SELECT AVG("pick") FROM "table_name_76" WHERE "2" = "round" AND "canada" = "nationality" AND "draft" > 1996 AND "josh green" = "player"