Table: mbta_bus_specs
Columns: order_year
manufacturer
model
fleet_qty
propulsion
length_ft

Question: Which Model has hybrid propulsion?
SQL: SELECT "model" FROM mbta_bus_specs WHERE "propulsion" = 'hybrid'

Question: What is the Propulsion for the model offered in 2003-2004 by neoplan usa?
SQL: SELECT "propulsion" FROM mbta_bus_specs WHERE "order_year" = '2003-2004' AND "manufacturer" = 'neoplan usa'

Question: What is the Length (ft.) for a 2008 nfi d40lf?
SQL: SELECT "length_ft" FROM mbta_bus_specs WHERE "manufacturer" = 'nfi' AND "model" = 'd40lf' AND "order_year" = '2008'