SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*) ASC
Return the different statuses of cities, ascending by frequency.
SELECT Status FROM city GROUP BY Status ORDER BY COUNT ( * ) ASC
select status from city group by status order by count ( * ) asc
Return the different statuses of cities , ascending by frequency .