题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
https://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
select o.id, is_group_buy, case is_group_buy when 'Yes' then 'None' else c.name end as client_name
from order_info o left join client c on o.client_id = c.id
where product_name in ('C++','Python','Java') and status = 'completed' and date > '2025-10-15' and user_id in (select user_id
from order_info
where product_name in ('C++','Python','Java') and status = 'completed' and date > '2025-10-15'
group by user_id
having count(id) >= 2)
