select sex,age,mobile_type,COUNT(1) num,grouping_id(sex,age,mobile_type) from per_rain..sht1126
group by
grouping sets
(
(),
(sex),
(sex,age,mobile_type)
group by
grouping sets
(
(),
(sex),
(sex,age,mobile_type)
)
order by grouping_id(sex,age,mobile_type) desc
order by grouping_id(sex,age,mobile_type) desc