Table: mta_bus_data
Columns: builder
model
length_ft_m
order_year
fuel_propulsion
fleet_series_quantity

Question: Which builder has a Fuel Propulsion of diesel, a Model of d40lf, and an Order Year of 2005?
SQL: SELECT "builder" FROM mta_bus_data WHERE "fuel_propulsion" = 'diesel' AND "model" = 'd40lf' AND "order_year" = '2005'

Question: Which model has a Fleet Series (Quantity) of 11081-11092 (12)?
SQL: SELECT "model" FROM mta_bus_data WHERE "fleet_series_quantity" = '11081-11092 (12)'

Question: Which order year has a Fleet Series (Quantity) of 12081-12090 (10)?
SQL: SELECT "order_year" FROM mta_bus_data WHERE "fleet_series_quantity" = '12081-12090 (10)'

Question: Which Fleet Series (Quantity) that has a Builder of mci, and an Order Year of 2002?
SQL: SELECT "fleet_series_quantity" FROM mta_bus_data WHERE "builder" = 'mci' AND "order_year" = '2002'

Question: Which Fleet Series (Quantity) has an Order Year of 2010, and a Model of de40lfr?
SQL: SELECT "fleet_series_quantity" FROM mta_bus_data WHERE "order_year" = '2010' AND "model" = 'de40lfr'

Question: Which Fuel Propulsion has a Fleet Series (Quantity) of 04001-04125 (125)?
SQL: SELECT "fuel_propulsion" FROM mta_bus_data WHERE "fleet_series_quantity" = '04001-04125 (125)'