CREATE TABLE table_78940 ("City" CLOB, "Country" CLOB, "Airport" CLOB, "IATA" CLOB, "ICAO" CLOB)

What is City of Sandefjord in Norway's IATA?
SELECT "IATA" FROM table_78940 WHERE "Country" = 'norway' AND "City" = 'sandefjord'
SELECT "IATA" FROM "table_78940" WHERE "City" = 'sandefjord' AND "Country" = 'norway'