在走神的马来熊

分类

/ 注册

全部文章（共37篇）

题解 | #今天的刷题量(一)#

with a as( select subject_id,count(subject_id) cnt from submission where create_time='2024-07-28' group by subject_id ) select nam...

2024-07-28

0 119

题解 | #网易云音乐推荐(网易校招笔试真题)#

with fid as(select f.user_id,follower_id,music_id from follow f left join music_likes m on f.follower_id=m.user_id where f.user_id=1 and music_id not ...

2024-07-28

0 94

题解 | #获得积分最多的人(二)#

with g as( select user_id,sum(grade_num) gn from grade_info where type='add' group by user_id ) select g.user_id,u.name,gn from g joi...

2024-07-15

1 138

题解 | #最差是第几名(二)#

破题，不看提示硬控我五个小时，最后参考区间法做出 with median as ( select grade,number,he,add_up,med,lag(add_up)over(order by grade) la from (select grade,number...

2024-07-09

1 144

题解 | #实习广场投递简历分析(三)#

with fir as( select job,left(date,7) mon1,month(date) m1,sum(num) s1 from resume_info where year(date)='2025' group by job,mon1,m1 ),s...

2024-06-16

1 178

题解 | #实习广场投递简历分析(二)#

select job,m,sum(num) from ( select *,left(date,7) m from resume_info ) t where year(date)='2025' group by job,m order by m desc,sum(num) desc;

2024-06-16

1 152

题解 | #牛客的课程订单分析(七)#

我发现模块化以后写的很快 with o as(select id,user_id,client_id,is_group_buy from ( select id,user_id,client_id,is_group_buy,count(id)over(partition by user_id...

2024-06-16

1 163

题解 | #牛客的课程订单分析(六)#

查询在2025-10-15以后，同一个用户下单2个以及2个以上状态为购买成功的C++课程或Java课程或Python课程的订单id，是否拼团以及客户端名字信息，最后一列如果是非拼团订单，则显示对应客户端名字，如果是拼团订单，则显示NULL，并且按照order_info的id升序排序 with o a...

2024-06-16

1 180

题解 | #牛客的课程订单分析(五)#

自己感觉最简单的一版了 select user_id,min(fir),min(sec),count(user_id) cnt from ( select user_id,date,fir,if(r1=2,date,null) sec from ( select us...

2024-06-15

1 145

题解 | #牛客的课程订单分析(四)#

select user_id,min(date),count(user_id) from ( select *,count(user_id)over(partition by user_id) xia from ( select * from orde...

2024-06-07

1 155