CREATE TABLE table_name_22 (red_list VARCHAR2, species_authority VARCHAR2, order VARCHAR2, family VARCHAR2)

What red list is in the artiodactyla order and the cervidae family with a Species Authority of odocoileus virginianus zimmermann, 1780?
SELECT red_list FROM table_name_22 WHERE order = "artiodactyla" AND family = "cervidae" AND species_authority = "odocoileus virginianus zimmermann, 1780"
SELECT "red_list" FROM "table_name_22" WHERE "artiodactyla" = "order" AND "cervidae" = "family" AND "odocoileus virginianus zimmermann, 1780" = "species_authority"