What sort of Fuel/Trans does the Grey & Red locomotive have?
CREATE TABLE "diesel_locomotives" (
  "name" text,
  "built" text,
  "wheels" text,
  "fuel_trans" text,
  "status" text,
  "colour" text
);
SELECT "fuel_trans" FROM "diesel_locomotives" WHERE "colour"='grey & red';