CREATE TABLE table_24890 ("English short name  ( upper/lower case ) " CLOB, "Alpha-2 code" CLOB, "Alpha-3 code" CLOB, "Numeric code" FLOAT, "ISO 3166-2 codes" CLOB)

What is the alpha 2 code for the area also known as NZL?
SELECT "Alpha-2 code" FROM table_24890 WHERE "Alpha-3 code" = 'NZL'
SELECT "Alpha-2 code" FROM "table_24890" WHERE "Alpha-3 code" = 'NZL'