如何从数据库中使用SQL查询获取国家和城市的数量？

By running this query:

通过运行此查询：

select 
    c.name, count(s.name) as statecount,  
    sum(count(ci.name)) OVER() AS citycount 
from 
    countries c, states s, cities ci
where 
    ci.state_id = s.id 
    and s.country_id = c.id 
group by 
    s.name
select