Schema: CREATE TABLE airports (city VARCHAR)
Question: List the cities which have more than one airport and number of airports.
SQL: SELECT city, COUNT(*) FROM airports GROUP BY city HAVING COUNT(*) > 1