What is Fleet Number(s), when Quantity Preserved is "0", when Quantity Made is 1, and when Class is "Z"?
CREATE TABLE table_name_95 (fleet_number_s_ VARCHAR, class VARCHAR, quantity_preserved VARCHAR, quantity_made VARCHAR)
SELECT fleet_number_s_ FROM table_name_95 WHERE quantity_preserved = "0" AND quantity_made = "1" AND class = "z"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (fleet_number_s_ VARCHAR, class VARCHAR, quantity_preserved VARCHAR, quantity_made VARCHAR) Question: What is Fleet Number(s), when Quantity Preserved is "0", when Quantity Made is 1, and when Class is "Z"? [/INST] SELECT fleet_number_s_ FROM table_name_95 WHERE quantity_preserved = "0" AND quantity_made = "1" AND class = "z" </s>