存几分期许

分类

/ 注册

全部文章（共167篇）

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

select music_name from ( select follower_id from follow where user_id=1 ) a join music_likes b on a.follower_id=b.user_id join music c on ...

2025-08-17

0 40

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

select b.id, name, weight, cnt as total from ( select goods_id, sum(count) as cnt from trans group by goods_id ) a join goods b on a.goods...

2025-08-17

0 26

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

with t as ( select user_id, sum(grade) as grade from ( select user_id, case when type='add' then grade_num else -grade_num end...

2025-08-17

0 32

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

with t as ( select user_id, name, sum_grade from ( select user_id, sum(grade_num) over (partition by user_id) as sum_grade fro...

2025-08-17

0 47

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

with t as ( select name, sum_grade from ( select user_id, sum(grade_num) over (partition by user_id) as sum_grade from grade_i...

2025-08-17

0 39

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

with t as ( select grade, number, (select sum(number) from class_grade) as total, sum(number) over (order by grade) as sum1, sum(numbe...

2025-08-17

0 45

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

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

2025-08-17

0 43

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

with t as ( select job, date_format(date, '%Y-%m') as month, sum(num) as cnt from resume_info where year(date) in (2025, 2026) group b...

2025-08-17

0 43

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

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

2025-08-17

0 35

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

select job, sum(num) as cnt from resume_info where year(date)=2025 group by job order by cnt desc

2025-08-17

0 40