Tendernessnick

分类

/ 注册

全部文章（共114篇）

题解 | 每个月Top3的周杰伦歌曲

# 年龄 2022年每个月播放次数前三周杰伦 with t1 as( select cast(date_format(fdate,'%m') as unsigned) as month, song_name, song_id fr...

2025-11-12

0 16

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

with t1 as( select user_id, date, min(date)over(partition by user_id order by date) as first_date from login )...

2025-11-12

0 20

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

with t1 as( select job, date_format(date,'%Y-%m') as first_year_mon, sum(num) as first_year_cnt from resume_in...

2025-11-11

0 22

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

with t1 as( select user_id, ( case when type='add' then grade_num else -grade_num ...

2025-11-11

0 21

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

with t1 as( select user_id, sum(grade_num) as grade_num from grade_info group by user_id ), t2 as( sel...

2025-11-11

0 14

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

with t1 as( select user_id, sum(grade_num) as grade_num from grade_info group by user_id ), t2 as( sel...

2025-11-11

0 17

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

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

2025-11-10

0 15

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

# 给1推荐他关注的人所喜欢的音乐 with t1 as( select distinct music_id from follow as f left join music_likes as ml on f.follo...

2025-11-10

0 18

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

select goods.id as id, name, weight, sum(trans.count) as total from trans left join goods on trans.goods_id=goods.id where we...

2025-11-07

0 29

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

select job, date_format(date,'%Y-%m') as mon, sum(num) as cnt from resume_info where date_format(date,'%Y')=2025 group by job,...

2025-11-07

0 26