When was John Hoan Trinh Doan / St. John Hoan, who was beatified in 1909 and canonised after 1988, martyred?
CREATE TABLE "saints" (
  "name" text,
  "martyred" real,
  "place" text,
  "beatified" real,
  "canonised" real
);
SELECT MAX("martyred") FROM "saints" WHERE "beatified"=1909 AND "name"='john hoan trinh doan / st. john hoan' AND "canonised">1988;