CREATE TABLE airports (city VARCHAR)

List the cities which have more than one airport and number of airports.
SELECT city, COUNT(*) FROM airports GROUP BY city HAVING COUNT(*) > 1
SELECT "city", COUNT(*) FROM "airports" GROUP BY "city" HAVING COUNT(*) > 1