select B.省统计, A.市统计, A.省, A.市 from (select 省,市,count(市) 市统计 from table group by 省,市) A inner join (select 省,count(省) 省统计 from table group by 省) B on A.省= B.省
select 省, 市,count(*) as 市统计, (select count(*) from 例子 where 省=a.省) as 省统计 from 例子 a group by 省, 市
(select 省,市,count(市) 市统计 from table group by 省,市) A
inner join
(select 省,count(省) 省统计 from table group by 省) B
on A.省= B.省
(select count(*) from 例子 where 省=a.省) as 省统计
from 例子 a
group by 省, 市