海阔天空alphabetago
海阔天空alphabetago
全部文章
分类
归档
标签
去牛客网
登录
/
注册
海阔天空alphabetago的博客
全部文章
(共17篇)
题解 | #牛客的课程订单分析(六)#
SELECT id ,is_group_buy ,name FROM ( SELECT order_info.id AS id, order_info.is_group_buy AS is_group_b...
2023-10-08
0
122
题解 | #牛客的课程订单分析(五)#
select a.user_id, max(case when a.r=1 then a.date else 0 end) as first_buy_date, max(case when a.r=2 then a.date else 0 end) as second_buy_date, a.cnt...
2023-10-08
0
136
题解 | #牛客的课程订单分析(五)#
SELECT order_info_ext.user_id AS user_id, min(first_buy_date) AS first_buy_date, min(date) AS second_buy_date, min(cnt) AS cnt FROM...
2023-10-08
0
125
题解 | #牛客的课程订单分析(四)#
SELECT order_info_ext.user_id AS user_id, MIN(date) AS first_buy_date, COUNT(*) AS cnt FROM ( SELECT *, COUNT(*...
2023-10-08
0
93
题解 | #牛客的课程订单分析(三)#
SELECT order_info.* FROM ( SELECT * FROM order_info WHERE date > '2025-10-15' AND stat...
2023-10-08
0
98
题解 | #考试分数(三)#
SELECT grade_rank.id ,language.name ,grade_rank.score FROM ( SELECT * ,dense_rank() over(partition by language_i...
2023-10-08
0
126
题解 | #牛客每个人最近的登录日期(六)#
SELECT `user`.name AS name, t2.`date`, SUM(t1.number) AS cnt FROM passing_number AS t1 JOIN passing_number AS t2 ON t1.u...
2023-10-08
0
113
首页
上一页
1
2
下一页
末页