题解 | #分群并计算群体人数#
分群并计算群体人数
https://www.nowcoder.com/practice/24319fd5c03e482c935783107114933d
select age_group,count(age_group) user_count from ( select case when age<20 then '20以下' when age<51 then '20-50' when age>50 then '50以上' else '未填写' end age_group from customers_info ) s group by age_group