Database: flight_4
Question: How many cities are there that have more than 3 airports?
SQL:
SELECT count(*) FROM (SELECT city FROM airports GROUP BY city HAVING count(*)  >  3)