CREATE TABLE table_name_2 (year VARCHAR2, numbers__quantity_ordered_ VARCHAR2, fuel_propulsion VARCHAR2, length VARCHAR2)

What year was the diesel fuel propulsion, with a length of 40', and numbers (quanity ordered) of 3701-3729 (29 buses), retired?
SELECT year AS Retired FROM table_name_2 WHERE fuel_propulsion = "diesel" AND length = "40'" AND numbers__quantity_ordered_ = "3701-3729 (29 buses)"
SELECT "year" AS "Retired" FROM "table_name_2" WHERE "3701-3729 (29 buses)" = "numbers__quantity_ordered_" AND "40'" = "length" AND "diesel" = "fuel_propulsion"