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

Which city has the ICAO of LIRF?
SELECT "City" FROM table_51595 WHERE "ICAO" = 'lirf'
SELECT "City" FROM "table_51595" WHERE "ICAO" = 'lirf'