牛客794288350号

分类

/ 注册

全部文章（共53篇）

题解 | 查询下订单用户访问次数？

SELECT o.user_id, COUNT(*) as visit_nums FROM ( SELECT DISTINCT user_id FROM order_tb ot W...

2025-05-06

0 40

题解 | 每个商品的销售总额

SELECT name AS product_name, total_sales, RANK() OVER ( PARTITION BY category ORDER BY total_sales...

2025-04-29

0 46

题解 | 推荐内容准确的用户平均评分

SELECT AVG(score) FROM( SELECT DISTINCT rt.rec_user, ua.score FROM recommend_tb rt LEFT JOIN user_action_...

2025-04-29

0 67