Table: bus_fleet_info
Columns: make_model
length
year
numbers_quantity_ordered
fuel_propulsion

Question: How many years have a Make/ Model of new flyer c40lfr?
SQL: SELECT COUNT("year") FROM bus_fleet_info WHERE "make_model" = 'new flyer c40lfr'

Question: Which Make/ Model that Numbers (Quantity Ordered) of 1461–1500 (40 buses)?
SQL: SELECT "make_model" FROM bus_fleet_info WHERE "numbers_quantity_ordered" = '1461–1500 (40 buses)'

Question: Which Fuel Propulsion has Numbers (Quantity Ordered) of 7124-7156 (33 buses)?
SQL: SELECT "fuel_propulsion" FROM bus_fleet_info WHERE "numbers_quantity_ordered" = '7124-7156 (33 buses)'

Question: Which Numbers (Quantity Ordered) have a Fuel Propulsion of cng, and a Year smaller than 2008, and a Make/ Model of nabi 40-lfw?
SQL: SELECT "numbers_quantity_ordered" FROM bus_fleet_info WHERE "fuel_propulsion" = 'cng' AND "year" < 2008 AND "make_model" = 'nabi 40-lfw'

Question: Which Numbers (Quantity Ordered) have a Make/ Model of eldorado national passport?
SQL: SELECT "numbers_quantity_ordered" FROM bus_fleet_info WHERE "make_model" = 'eldorado national passport'