题解 | #牛客的课程订单分析(二)#
牛客的课程订单分析(二)
https://www.nowcoder.com/practice/4ca4137cb490420cad06d2147ae67456
select user_id
from order_info
where status='completed'
and product_name in ('C++','Java','Python')
and datediff(date,'2025-10-15')>0
group by user_id
having count(*)>1
order by user_id
- 注意筛选条件
- 日期
- 课程
- 订单状态
- 使用having筛选下单数大于1的用户
