题解 | #牛客的课程订单分析(三)#gary
牛客的课程订单分析(三)
http://www.nowcoder.com/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
select id, user_id, product_name, status, client_id, date
from (
select *, count(id) over(partition by user_id) as cnt
from order_info
where datediff(date,"2025-10-15")>0
and status ="completed"
and product_name in ("C++","Java","Python")
) x
where x.cnt > 1
order by x.id
饿了么公司氛围 82人发布