List the official names of all the cities.
select distinct official_name from city
Show me all the status of these cities.
select distinct status from city
What is the number of cities with each status?
select status, count(*) from city group by status
Can you show them in increasing order?
select status from city group by status order by count(*) asc