list all cities.
select city from airports
how many airports does each city have?
select city, count(*) from airports group by city
just show cities that have more than one airport.
select city from airports group by city having count(*) > 1
include the number of airports per city.
select city, count(*) from airports group by city having count(*) > 1