SELECT city ,  count(*) FROM airports GROUP BY city HAVING count(*)  >  1
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 ( * ) > value
List the cities which have more than one airport and number of airports .