笨办法
SELECT
user_id,
first_buy_date,
SUM(cnt)
FROM (
SELECT
user_id,
min(date) over(partition by user_id ) as first_buy_date,
count(user_id) as cnt
FROM order_info
WHERE date > '2025-10-15'
AND status = 'completed'
AND user_id IN ( SELECT user_id FROM(SELECT
user_id,
COUNT(product_name) AS DC1
FROM order_info
WHERE date > DATE("2025-10-15")
AND status = 'completed'
AND product_name IN ('C++', 'Java', 'Python')
GROUP BY user_id
order by user_id
) AS GJJJ
WHERE GJJJ.DC1 >= 2
)
AND product_name IN ('C++','Java','Python')
group by user_id,date
order by user_id
) AS KLL
GROUP BY user_id,
first_buy_date
SELECT
user_id,
first_buy_date,
SUM(cnt)
FROM (
SELECT
user_id,
min(date) over(partition by user_id ) as first_buy_date,
count(user_id) as cnt
FROM order_info
WHERE date > '2025-10-15'
AND status = 'completed'
AND user_id IN ( SELECT user_id FROM(SELECT
user_id,
COUNT(product_name) AS DC1
FROM order_info
WHERE date > DATE("2025-10-15")
AND status = 'completed'
AND product_name IN ('C++', 'Java', 'Python')
GROUP BY user_id
order by user_id
) AS GJJJ
WHERE GJJJ.DC1 >= 2
)
AND product_name IN ('C++','Java','Python')
group by user_id,date
order by user_id
) AS KLL
GROUP BY user_id,
first_buy_date
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2Fc93d2079282f4943a3771ca6fd081c23
全部评论
相关推荐
04-12 21:52
南开大学 Java
何时能不做牛马:简历每个点之间的间距可以缩一下。几乎没遇到过要演示项目的情况,即使万一遇上了你也可以说部署在其他电脑上本地没代码。nku不应该简历挂吧?抓紧背背八股练练表达,不要放弃,五六月份找到也不晚(不然还得提前入职 点赞 评论 收藏
分享
查看11道真题和解析