CREATE TABLE table_name_9 (manufacturer VARCHAR2, fuel_type VARCHAR2)

What is the Manufacturer with a Fuel Type that is diesel?
SELECT manufacturer FROM table_name_9 WHERE fuel_type = "diesel"
SELECT "manufacturer" FROM "table_name_9" WHERE "diesel" = "fuel_type"