WHAT IS THE BIRTH DATE THAT HAS Ceased to be Duke of Girona OF 21 NOVEMBER 1582?
CREATE TABLE "holders" (
  "name" text,
  "heir_of" text,
  "birth" text,
  "ceased_to_be_duke_of_girona" text,
  "death" text
);
SELECT "birth" FROM "holders" WHERE "ceased_to_be_duke_of_girona"='21 november 1582';