CREATE TABLE table_43237 ("Manufacturer" CLOB, "Model" CLOB, "Year Built" FLOAT, "Vehicle Length" CLOB, "Fuel Type" CLOB, "# in fleet" FLOAT)

What is the Manufacturer with a Fuel Type that is diesel?
SELECT "Manufacturer" FROM table_43237 WHERE "Fuel Type" = 'diesel'
SELECT "Manufacturer" FROM "table_43237" WHERE "Fuel Type" = 'diesel'