一道简单的sql练习题:统计客户数和订单数

原创于 2022-05-27 20:52:30 发布 · 2.3k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#sql

SQL 专栏收录该内容

14 篇文章

订阅专栏

本文介绍了一种通过SQL查询来按订单数量进行分段统计的方法。该查询首先根据指定日期范围内的订单数量将用户分为几个不同的组别，然后计算每个组别的用户数，以便更好地了解用户的购买行为。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在这里插入图片描述

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