SELECT city ,  count(*) FROM airports GROUP BY city HAVING count(*)  >  1
What are the names of all cities with more than one airport and how many airports do they have?
SELECT city , count ( * ) FROM airports GROUP BY city HAVING count ( * ) > 1
select city , count ( * ) from airports group by city having count ( * ) > value
What are the names of all cities with more than one airport and how many airports do they have ?