What is the average pick of player josh green from Canada from round 2 with a draft after 1996?
CREATE TABLE table_name_76 (pick INTEGER, draft VARCHAR, player VARCHAR, round VARCHAR, nationality VARCHAR)
SELECT AVG(pick) FROM table_name_76 WHERE round = "2" AND nationality = "canada" AND player = "josh green" AND draft > 1996
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (pick INTEGER, draft VARCHAR, player VARCHAR, round VARCHAR, nationality VARCHAR) Question: What is the average pick of player josh green from Canada from round 2 with a draft after 1996? [/INST] SELECT AVG(pick) FROM table_name_76 WHERE round = "2" AND nationality = "canada" AND player = "josh green" AND draft > 1996 </s>