JJJENNN

分类

/ 注册

全部文章（共38篇）

题解 | 被重复观看次数最多的3个视频

select cid, round(num_cid*1.000,3) as pv, row_number() over(order by round(num_cid*1.000,3) desc,c.release_date desc) as rk from ( select uid, ...

2026-02-28

0 47

题解 | 查询成绩

select count(*) from( select s.sId from SC join Course c using (cId) join Student s using (sId) where c.cname = '语文' ...

2026-02-24

0 29

题解 | 请写出计算粉丝ctr的sql语句

select round(sum(c.read_num) / sum(c.show_num),4) as fans_ctr from a join b using (author_id) join c using (content_id) where a.fans_id = c.fans_i...

2026-02-24

0 31

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

select g.id, g.name, g.weight, sum(t.count) as total from trans t left join goods g on g.id = t.goods_id group by g.id,g.name,g.weigh...

2026-02-24

0 31

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

select music_name from ( select music_id from music_likes ml where user_id in ( ...

2026-02-24

0 39

题解 | 支付间隔平均值

select cast(round(avg(abs(timestampdiff(second,o.time,s.time)) ),0) as unsigned) as gap from order_log o join select_log s using (order_id)

2026-02-24

0 26

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

with early as ( select date(log_time) as log_day, min(log_time) as early_time from login_tb group by date(log_time) ) sel...

2026-02-24

0 28

题解 | 统计加班员工占比

select department, concat( round( sum( if(timestampdiff(second,at.first_clockin,at.last_clockin) /...

2026-02-24

0 33

题解 | 最长连续登录天数

SELECT user_id, MAX(datee) AS max_consec_days FROM ( SELECT user_id, MAX(d_rank) - MIN(d_rank)+1 AS datee FROM ( ...

2026-02-16

0 36

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

SELECT department, ROUND(avg(normal_salary - dock_salary),3) AS avg_salary FROM staff_tb JOIN salary_tb USING (staff_id) WHERE normal_salary ...

2026-02-16

0 29