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

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