Table: npr_locomotives_2
Columns: class
wheel_arrangement
fleet_number_s
manufacturer
serial_numbers
year_made
quantity_made
quantity_preserved

Question: What is the quantity preserved for fleet number(s) 3000–3015?
SQL: SELECT "quantity_preserved" FROM npr_locomotives_2 WHERE "fleet_number_s" = '3000–3015'

Question: What manufacturer has a wheel arrangement of 4-6-6-4, and a Class of z-7?
SQL: SELECT "manufacturer" FROM npr_locomotives_2 WHERE "wheel_arrangement" = '4-6-6-4' AND "class" = 'z-7'

Question: What is the Year for fleet number 5000?
SQL: SELECT "year_made" FROM npr_locomotives_2 WHERE "fleet_number_s" = '5000'

Question: What year made has a Quantity made of 4?
SQL: SELECT "year_made" FROM npr_locomotives_2 WHERE "quantity_made" = '4'

Question: What is the quantity preserved for the serial number of mallet and simple articulated locomotives?
SQL: SELECT "quantity_preserved" FROM npr_locomotives_2 WHERE "serial_numbers" = 'mallet and simple articulated locomotives'