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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the average pick of player josh green from Canada from round 2 with a draft after 1996? ### Input: CREATE TABLE table_name_76 (
    pick INTEGER,
    draft VARCHAR,
    player VARCHAR,
    round VARCHAR,
    nationality VARCHAR
) ### Response: SELECT AVG(pick) FROM table_name_76 WHERE round = "2" AND nationality = "canada" AND player = "josh green" AND draft > 1996