What soap opera has a rank larger than 1, and a Character named Emily Bishop?
CREATE TABLE "top_10_across_all_platforms" (
  "rank" real,
  "actor" text,
  "character" text,
  "soap_opera" text,
  "years" text,
  "duration" text
);
SELECT "soap_opera" FROM "top_10_across_all_platforms" WHERE "rank">1 AND "character"='emily bishop';