SELECT COUNT(*), city FROM airports WHERE country = 'United States' GROUP BY city ORDER BY COUNT(*) DESC
Berapa banyak bandara per kota di Amerika Serikat?Pesan kota dengan mengurangi jumlah bandara.
CREATE TABLE airports (city VARCHAR, country VARCHAR)