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

What is the IATA when France was the country, and the ICAO was lfrn?
SELECT "IATA" FROM table_40047 WHERE "Country" = 'france' AND "ICAO" = 'lfrn'
SELECT "IATA" FROM "table_40047" WHERE "Country" = 'france' AND "ICAO" = 'lfrn'