when did new zealand last compete?
CREATE TABLE "replaced_pageants" (
  "country_territory" text,
  "former_pageant" text,
  "last_competed" real,
  "new_pageant" text,
  "franchise_since" real
);
SELECT MAX("last_competed") FROM "replaced_pageants" WHERE "country_territory"='New Zealand';