Please show the different statuses, ordered by the number of cities that have each.
SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*) ASC
different statuses refers to DISTINCT(Status); ordered by the number of cities refers to ORDER BY COUNT(*);