题解 | #分群并计算群体人数#
分群并计算群体人数
https://www.nowcoder.com/practice/24319fd5c03e482c935783107114933d
select if(age<20,'20以下',if(age<=50,'20-50' ,if(age>50,'50以上','未填写'))) age_group,count(customer_id) user_count
from customers_info
group by age_group
分群并计算群体人数
https://www.nowcoder.com/practice/24319fd5c03e482c935783107114933d
select if(age<20,'20以下',if(age<=50,'20-50' ,if(age>50,'50以上','未填写'))) age_group,count(customer_id) user_count
from customers_info
group by age_group
相关推荐