CREATE TABLE table_19228 ("Country/Territory" CLOB, "Former pageant" CLOB, "Last competed" FLOAT, "New pageant" CLOB, "Franchise since" FLOAT)

when did new zealand last compete?
SELECT MAX("Last competed") FROM table_19228 WHERE "Country/Territory" = 'New Zealand'
SELECT MAX("Last competed") FROM "table_19228" WHERE "Country/Territory" = 'New Zealand'