Which locomotive type has a status in static display
CREATE TABLE "locomotives" (
  "no" real,
  "name" text,
  "livery" text,
  "locomotive_type" text,
  "wheel_arrangement" text,
  "builder" text,
  "year_built" real,
  "status" text
);
SELECT "locomotive_type" FROM "locomotives" WHERE "status"='Static display';