how many airports does the US has?
select count(*) from airports where country = 'United States'
what is the number of airports in each city in the US?
select count(*), city from airports where country = 'United States' group by city
Order the cities by decreasing number of airports.
select count(*), city from airports where country = 'United States' group by city order by count(*) desc