SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*) ASC
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
select status from city group by status order by count ( * ) asc
Please show the different statuses , ordered by the number of cities that have each .