Database: flight_4
Question: How many airports are there per city in the United States? Order the cities by decreasing number of airports.
SQL:
SELECT count(*) ,  city FROM airports WHERE country  =  'United States' GROUP BY city ORDER BY count(*) DESC