CREATE TABLE table_42243 ("City" CLOB, "Province" CLOB, "Country" CLOB, "IATA" CLOB, "Airport" CLOB)

Which province's IATA is kix?
SELECT "Province" FROM table_42243 WHERE "IATA" = 'kix'
SELECT "Province" FROM "table_42243" WHERE "IATA" = 'kix'