How many airports are there per city in the United States? Order the cities by decreasing number of airports.
select count(*), city from airports where country = 'United States' group by city order by count(*) desc