牛客926165907号

分类

/ 注册

全部文章（共46篇）

题解 | 最长连续登录天数

select user_id, max(cnt) as max_consec_days from( select user_id, date_add(fdate, interval -t_rk day) as first_date, count(*) over( partit...

2025-08-20

0 53

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

select name, count(*) as cnt from submission left join subject on submission.subject_id = subject.id where create_time = curdate() group by name, subj...

2025-08-14

0 27

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

select music_name from( select music_id from music_likes where user_id in( select follower_id from follow where user_id = 1 ...

2025-08-14

0 50

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

select goods.id, name, weight, sum(count) as total from trans left join goods on trans.goods_id = goods.id where weight < 50 group by goods.id, nam...

2025-08-14

0 42

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

with tb1 as( select id, name, case when type = 'reduce' then -1 * grade_num else grade_num end as grade_num1 from grade_info left join use...

2025-08-14

0 50

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

with tb1 as( select id, name, sum(grade_num) as grade_num from grade_info left join user on grade_info.user_id = user.id group by id, name...

2025-08-14

0 51

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

select name, sum(grade_num) as grade_num from grade_info left join user on grade_info.user_id = user.id group by name order by grade_num desc limit 1

2025-08-14

0 37

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

select grade from( select grade, case when floor((rk2 + 1) / 2) between rk0 and rk1 or ceil((rk2 + 1) / 2) between rk0 and rk1 then 1 els...

2025-08-14

0 36

题解 | 最差是第几名(一)

select grade, sum(number) over(order by grade) as t_rank from class_grade

2025-08-13

0 40

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

with tb2025 as( select job, date_format(date, "%Y-%m") as first_year_mon, sum(num) as first_year_cnt from resume_info where yea...

2025-08-13

0 40