How many airports are there per country? Order the countries by decreasing number of airports.
CREATE TABLE airports (country VARCHAR)
SELECT COUNT(*), country FROM airports GROUP BY country ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE airports (country VARCHAR) Question: How many airports are there per country? Order the countries by decreasing number of airports. [/INST] SELECT COUNT(*), country FROM airports GROUP BY country ORDER BY COUNT(*) DESC </s>