Database: flight_4
Question: List all countries and their number of airlines in the descending order of number of airlines.
SQL:
SELECT country ,  count(*) FROM airlines GROUP BY country ORDER BY count(*) DESC