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