显示不同的州及其城市数量

Try the following. You should read and learn basics about SQL here.

select
    state,
    count(distinct city) as total_city
from yourTable
group by
    state
order by
    total_city desc

您可以尝试此查询。

SELECT state,count(city) from <tablename> group by state order by state desc.