select
case
when order_nums <= 5 then '0-5'
when order_nums>=6 and order_nums<=10 then '6-10'
when order_nums>=11 and order_nums<=20 then '11-20'
else '20以上'
end as sale_nums,
count(1) as user_nums
from
(
select
user_id,
count(1) AS order_nums
from
table_order
where
create_date>='2020-05-01' and create_date<='2020-05-31'
group by
user_id
)t
group by
case
when order_nums <= 5 then '0-5'
when order_nums>=6 and order_nums<=10 then '6-10'
when order_nums>=11 and order_nums<=20 then '11-20'
else '20以上'
end
一道简单的sql练习题:统计客户数和订单数
最新推荐文章于 2024-06-07 10:00:00 发布