题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
牛客的课程订单分析(四)
http://www.nowcoder.com/practice/c93d2079282f4943a3771ca6fd081c23
select t2.user_id,t2.first_buy_date,t1.cnt
from
#查询出cnt>1的user_id
(select user_id,count(*) cnt
from order_info
where date > "2025-10-15" and product_name in ("C++","Python","Java")
and status = "completed" GROUP BY user_id) t1,
#查询mindate
(select user_id,min(date) first_buy_date
from order_info
where date > "2025-10-15" and product_name in ("C++","Python","Java")
and status = "completed" GROUP BY user_id) t2
#两表关联
where t2.user_id = t1.user_id and t1.cnt > 1 order by user_id
