text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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?
  ### Answer:
  SELECT AVG(pick) FROM table_name_76 WHERE round = "2" AND nationality = "canada" AND player = "josh green" AND draft > 1996