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

which is the new pageant from spain?
SELECT "New pageant" FROM table_19230 WHERE "Country/Territory" = 'Spain'
SELECT "New pageant" FROM "table_19230" WHERE "Country/Territory" = 'Spain'