牛客752205773号

分类

题解(55)

/ 注册

全部文章（共42篇）

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

select d.music_name from( select distinct c.music_name,c.music_id from (select a.follower_id from follow a where a.user_id = '1' ) b left join ( sel...

Mysql

2022-06-30

0 249

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

select t.id,t.name,t.weight,t1.counts from goods t right join (select distinct goods_id, sum(count)over(partition by goods_id) counts from trans ) ...

Mysql

2022-06-30

0 250

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

select t.id,t.name,t1.grade_num from user t right join ( select distinct user_id,sum(if(type='add',grade_num,-1*grade_num))over(partition by user_i...

Mysql

2022-06-30

0 251

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

select t.id,t.name,t1.grade_num from user t right join ( select distinct user_id,sum(grade_num)over(partition by user_id) grade_num from grade_inf...

Mysql

2022-06-30

0 237

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

select t.name,t1.grade_num from user t right join ( select distinct user_id,sum(grade_num)over(partition by user_id) grade_num from grade_info )t1...

Mysql

2022-06-30

1 350

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

select t2.grade from ( select t1.grade, case when mod(t1.total,2)=0 then total/2 else (total+1)/2 end star, case when mod(t1.total,2)=0 then total/2+1...

Mysql

2022-06-29

0 279

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

select a.grade, sum(a.number)over(order by a.grade) from class_grade a order by 1 或 select grade, case when grade='A' then (select sum(t.number) fro...

Mysql

2022-06-29

0 278

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

select distinct t1.job,t1.first_yeat_mom,t1.ct1,t2.second_yeat_mom,t2.ct2 from (select distinct job,date, substr(date,1,7) first_yeat_mom, sum(num)ove...

Mysql

2022-06-28

0 384

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

select distinct job, substr(date,1,7) mon, sum(num)over(partition by substr(date,1,7),job) from resume_info where substr(date,1,4)='2025' order by 2 d...

Mysql

2022-06-28

0 261

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

select distinct job, sum(num)over(partition by job) from resume_info where substr(date,1,4)='2025' order by 2 desc

Mysql

2022-06-28

0 264