List the cities which have more than one airport and number of airports.
CREATE TABLE airports (city VARCHAR)
SELECT city, COUNT(*) FROM airports GROUP BY city HAVING COUNT(*) > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE airports (city VARCHAR) Question: List the cities which have more than one airport and number of airports. [/INST] SELECT city, COUNT(*) FROM airports GROUP BY city HAVING COUNT(*) > 1 </s>