What is the latest year for the role of joan gordon, aka francine la rue?
CREATE TABLE "films" (
  "year" real,
  "film" text,
  "role" text,
  "leading_man" text,
  "director" text
);
SELECT MAX("year") FROM "films" WHERE "role"='joan gordon, aka francine la rue';