题解 | #牛客的课程订单分析(六)#

sql script

select oi.id, oi.is_group_buy, c.name as client_name
from order_info oi left join client c on oi.client_id=c.id
where user_id in (select user_id
                  from order_info
                  where date >= '2025-10-15'
                  and status='completed'
                  and product_name in ('C++', 'Java', 'Python')
                  group by user_id
                  having count(product_name) >= 2
                  order by user_id)
and date >= '2025-10-15'
and status='completed'
and product_name in ('C++', 'Java', 'Python')