SELECT count(*) ,  city FROM airports WHERE country  =  'United States' GROUP BY city ORDER BY count(*) DESC
How many airports are there per city in the US ordered from most to least?
SELECT count ( * ) , city FROM airports WHERE country = 'United States ' GROUP BY city ORDER BY count ( * ) DESC
select count ( * ) , city from airports where country = value group by city order by count ( * ) desc
How many airports are there per city in the US ordered from most to least ?