L重启中

分类

/ 注册

全部文章（共51篇）

题解 | 商品交易(网易校招笔试真题)

select g.id id ,name ,weight ,sum(count) from goods g join trans t on g.id = t.goods_id where weight < 50 group by 1,2,3 having sum(count)>...

2025-09-11

0 43

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

select music_name from music_likes m1 join follow m2 on m1.user_id = m2.follower_id join music m3 on m1.music_id = m3.id where m2.user_id = '1'...

2025-09-11

0 68

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

select music_name from ( select distinct id ,music_name from music_likes m1 join follow m2 on m1.user_id = m2.follower_id join music m3 on m1.m...

2025-09-11

0 96

题解 | 支付间隔平均值

select cast(avg(abs(timestampdiff(second,order_log.logtime,select_log.logtime))) as signed) gap from order_log join select_log on order_log.order_id =...

2025-09-10

0 47

题解 | 每天登陆最早的用户的内容喜好

select log_day ,user_id ,hobby from ( select date(log_time) log_day ,login_tb.user_id ,hobby ,dense_rank()over(partition by date(log_time) order by l...

2025-09-10

0 32

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

select order_tb.user_id ,count(distinct info_id) visit_nums from order_tb join visit_tb on order_tb.user_id = visit_tb.user_id where date(order_time) ...

2025-09-10

0 37

题解 | 统计用户从访问到下单的转化率

select date(visit_time) date ,concat(ROUND(count(distinct order_tb.user_id)/count(distinct visit_tb.user_id)*100,1),'%') cr from order_tb right join...

2025-09-10

0 39

题解 | 统计用户获得积分

select user_id ,sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) point from visit_tb group by 1 order by point desc

2025-09-10

0 29

题解 | 统计各个部门平均薪资

select department ,round(avg(normal_salary - dock_salary),3) avg_salary from salary_tb join staff_tb on salary_tb.staff_id = staff_tb.staff_id where n...

2025-09-10

0 36

题解 | 统计各个部门平均薪资

select department ,avg(act_salary) avg_salary from ( select staff_id ,round(normal_salary - dock_salary,3) act_salary from salary_tb where round(...

2025-09-10

0 41