Database: flight_4
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