MySQL 简易的数据统计-省、市、区、街的统计

我的mysql内的表格如下，有省、市、区、街、当期日期的字段

我想做一个简易的统计，结果如下，请问要如何写mysql的语法呢

select province,count(distinct city),count(distinct district),count(distinct street),date from table group by province,date

select province,count(distinct(city)),count(distinct(district)),count(distinct(street)),date from table group by province

select province as 希望结果,COUNT(distinct city) as 城市数,COUNT(distinct district) as 区域数,COUNT(street) as 街道数, currentdate as 当期日期 from dbo.test3 group by currentdate,province;