咕叽咕叽鲸

分类

/ 注册

全部文章（共5篇）

题解 | #零食类商品中复购率top3高的商品#

with a as( select t1.order_id,t1.product_id, t2.uid from tb_order_detail t1 left join tb_order_overall t2 on t1.order_id=t2.order_id l...

2024-02-04

0 171

题解 | #考试分数(三)#

SELECT id, name, score FROM ( SELECT g.id, l.name, score, DENSE_RANK() OVER (PARTITION BY l.name ORDER BY score DESC) AS ranking FROM grade g...

2023-06-17

0 239

题解 | #牛客每个人最近的登录日期(二)#

SELECT u.name AS u_n, c.name AS c_n, date FROM ( SELECT id, user_id, client_id, date, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY...

2023-06-14

0 177

题解 | #分别满足两个活动的人#

SELECT DISTINCT uid, 'activity1' AS sctivity FROM exam_record WHERE score >= 85 AND YEAR(submit_time)=2021 UNION SELECT DISTINCT uid, 'activity2' A...

2023-06-11

0 214

题解 | #未完成试卷数大于1的有效用户#

SELECT uid, incomplete_cnt, complete_cnt, ( SELECT GROUP_CONCAT(DISTINCT DATE(start_time),':',tag ORDER BY start_time SEPARATOR ';') FROM exam_recor...

2023-06-10

0 216