What red list is in the artiodactyla order and the cervidae family with a Species Authority of odocoileus virginianus zimmermann, 1780?
CREATE TABLE table_name_22 (red_list VARCHAR, species_authority VARCHAR, order VARCHAR, family VARCHAR)
SELECT red_list FROM table_name_22 WHERE order = "artiodactyla" AND family = "cervidae" AND species_authority = "odocoileus virginianus zimmermann, 1780"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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? [/INST] SELECT red_list FROM table_name_22 WHERE order = "artiodactyla" AND family = "cervidae" AND species_authority = "odocoileus virginianus zimmermann, 1780" </s>