Table: bus_routes_sd
Columns: order_year
fleet_series_qty
manufacturer
model
powertrain_engine_transmission
fuel_or_propulsion
division

Question: Name the powertrain for kmd and c40lf
SQL: SELECT "powertrain_engine_transmission" FROM bus_routes_sd WHERE "division" = 'KMD' AND "model" = 'C40LF'

Question: Name the division for  detroit diesel series 50egr allison wb-400r
SQL: SELECT "division" FROM bus_routes_sd WHERE "powertrain_engine_transmission" = 'Detroit Diesel Series 50EGR Allison WB-400R'

Question: Name the manufacturer for 2011
SQL: SELECT "manufacturer" FROM bus_routes_sd WHERE "order_year" = 2011