Table: mlw_diesel_locomotives_4
Columns: model
build_date
total_produced
wheel_arrangement
prime_mover
power_output

Question: What is the average total produced when the prime mover is 12-251c?
SQL: SELECT AVG("total_produced") FROM mlw_diesel_locomotives_4 WHERE "prime_mover" = '12-251c'

Question: What is the build date when total produced is 2?
SQL: SELECT "build_date" FROM mlw_diesel_locomotives_4 WHERE "total_produced" = 2

Question: What is the smallest total produced with a model of M-420?
SQL: SELECT MIN("total_produced") FROM mlw_diesel_locomotives_4 WHERE "model" = 'm-420'

Question: What is the prime mover for a build date in 1975?
SQL: SELECT "prime_mover" FROM mlw_diesel_locomotives_4 WHERE "build_date" = '1975'

Question: What model has a total produced more than 5 and a prime move of 12-251c?
SQL: SELECT "model" FROM mlw_diesel_locomotives_4 WHERE "total_produced" > 5 AND "prime_mover" = '12-251c'