Please show the different statuses, ordered by the number of cities that have each.
CREATE TABLE city (Status VARCHAR)
SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE city (Status VARCHAR) Question: Please show the different statuses, ordered by the number of cities that have each. [/INST] SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*) </s>