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

FROM (SELECT *
from order_info
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(*)>=2)
  and  date>"2025-10-15"          
  and status ="completed"
  and product_name in("C++","Java","Python"))a left join client c
  on a.client_id=c.id
  order by a.id;