CREATE TABLE table_name_40 (manufacturer VARCHAR2, type VARCHAR2)

Which manufacturer made a locomotive with a type of 4-6-4t?
SELECT manufacturer FROM table_name_40 WHERE type = "4-6-4t"
SELECT "manufacturer" FROM "table_name_40" WHERE "4-6-4t" = "type"