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_22 (red_list VARCHAR, species_authority VARCHAR, order VARCHAR, family VARCHAR)
  ### Question:
  What red list is in the artiodactyla order and the cervidae family with a Species Authority of odocoileus virginianus zimmermann, 1780?
  ### Answer:
  SELECT red_list FROM table_name_22 WHERE order = "artiodactyla" AND family = "cervidae" AND species_authority = "odocoileus virginianus zimmermann, 1780"