What role is Kevin Bishop the actor?
CREATE TABLE "others" (
  "character" text,
  "actor" text,
  "duration" text,
  "role" text,
  "appearances" text
);
SELECT "role" FROM "others" WHERE "actor"='kevin bishop';