CREATE TABLE table_12267 ("Draft" FLOAT, "Round" CLOB, "Pick" FLOAT, "Player" CLOB, "Nationality" CLOB)

What is the average pick of player josh green from Canada from round 2 with a draft after 1996?
SELECT AVG("Pick") FROM table_12267 WHERE "Round" = '2' AND "Nationality" = 'canada' AND "Player" = 'josh green' AND "Draft" > '1996'
SELECT AVG("Pick") FROM "table_12267" WHERE "Draft" > '1996' AND "Nationality" = 'canada' AND "Player" = 'josh green' AND "Round" = '2'