秋天的震撼已经感受到了😅😅😅

分类

/ 注册

全部文章（共80篇）

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

/*select distinct music_name from(select f.user_id,f.follower_id,ml.music_id,music_name from follow f right join music_likes ml on f.follower_id=ml.us...

2023-12-11

0 261

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

SELECT s.name, COUNT(*) AS cnt FROM submission AS sub JOIN subject AS s ON sub.subject_id = s.id WHERE DATE(sub.create_time) = CURDATE() GROUP BY s.na...

2023-12-11

0 244

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

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

2023-12-10

0 209

题解 | 变号

select id,name,sgn from(select id,name,sgn,rank()over(order by sgn desc) rk from(select user_id,sum(gn) sgn from(select user_id,case when type='add' t...

2023-12-10

1 228

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

select id,name,gn from(select id,name,gn,rank()over(order by gn desc) rk from (select user_id,sum(grade_num) gn from grade_info group by user_id) t le...

2023-12-10

0 194

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

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

2023-12-09

0 225

题解 | 中位数的问题转化成排序问题

select grade from (select grade,sum(number)over(order by grade) a,sum(number)over(order by grade desc) b from class_grade) t where a>=(select sum(n...

2023-12-09

1 219

题解 | 窗口函数累加

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

2023-12-09

0 219

限定为某一年内时，按'年+月'分组去重与按'月'分组去重一样

select t1.job job,first_year_mon,first_year_cnt,second_year_mon,second_year_cnt from (select job,date_format(date,'%Y-%m') first_year_mon,sum(num) fir...

2023-12-08

1 263

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

select job,date_format(date,'%Y-%m') mon,sum(num) count from resume_info where date>'2025-01-01' and date<'2025-12-31' group by mon,job order by...

2023-12-08

0 209