Database: flight_4
Question: What are the names of all cities with more than one airport and how many airports do they have?
SQL:
SELECT city ,  count(*) FROM airports GROUP BY city HAVING count(*)  >  1