Table: bus_fleet_info
Columns: make_model
length
year
numbers_quantity_ordered
fuel_propulsion
year_retired

Question: For the year 1975, what is Propulsion, with a Number (quantity ordered) of 4756-4788 (33 buses)?
SQL: SELECT "fuel_propulsion" FROM bus_fleet_info WHERE "year" = 1975 AND "numbers_quantity_ordered" = '4756-4788 (33 buses)'

Question: What is the make and model that retires in 2004, and has a numbers (quantity ordered) of 961-967 (7 buses)?
SQL: SELECT "make_model" FROM bus_fleet_info WHERE "year_retired" = '2004' AND "numbers_quantity_ordered" = '961-967 (7 buses)'

Question: What year was the diesel fuel propulsion, with a length of 40', and numbers (quanity ordered) of 3701-3729 (29 buses), retired?
SQL: SELECT "year_retired" FROM bus_fleet_info WHERE "fuel_propulsion" = 'diesel' AND "length" = '40''' AND "numbers_quantity_ordered" = '3701-3729 (29 buses)'