Table: locomotives_soo_line
Columns: class
wheel_arrangement
fleet_number_s
quantity_made
quantity_preserved

Question: What is Quantity made, when Wheel Arrangement is "2-6-0", and when Class is "D-3"?
SQL: SELECT "quantity_made" FROM locomotives_soo_line WHERE "wheel_arrangement" = '2-6-0' AND "class" = 'd-3'

Question: What is Fleet Number(s), when Wheel Arrangement is "2-6-0", and when Class is "Z"?
SQL: SELECT "fleet_number_s" FROM locomotives_soo_line WHERE "wheel_arrangement" = '2-6-0' AND "class" = 'z'

Question: What is Fleet Number(s), when Quantity Preserved is "0", when Quantity Made is 1, and when Class is "Z"?
SQL: SELECT "fleet_number_s" FROM locomotives_soo_line WHERE "quantity_preserved" = '0' AND "quantity_made" = '1' AND "class" = 'z'