Database: flight_4
Question: How many airports are there per city in the US ordered from most to least?
SQL:
SELECT count(*) ,  city FROM airports WHERE country  =  'United States' GROUP BY city ORDER BY count(*) DESC