SQL实战80 牛客的课程订单分析(四)

题目

解答

select user_id,min(date) as first_buy_date,count(user_id) as cnt
from order_info
where date > "2025-10-15"
and status = "completed"
and product_name in ("C++","Java","Python")
group by user_id
having count(user_id) > 1
order by user_id;