牛客207221769号

分类

题解(2)

/ 注册

全部文章（共57篇）

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

select music_name from( select distinct music_likes.music_id musicid from( select follower_id from follow where user_id=1 )t j...

2024-02-20

0 282

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

with t1 as( select user_id,sum(grade_num) grade_num from grade_info group by user_id ) select id,name,grade_num from t1 join user on t1.us...

2024-02-20

0 181

题解 | #牛客的课程订单分析(七)#

SELECT if(t.client_id = 0,"GroupBuy",name) source,count(1) FROM( select client_id from order_info where user_id in( sele...

2024-02-20

0 260

题解 | #牛客的课程订单分析(四)#

select user_id,min(date) first_buy_date,count(1) cnt from order_info where date>"2025-10-15" and status = "completed" and produ...

2024-02-19

0 264

题解 | #考试分数(四)#

select job,if(num&1,floor(num/2+1),floor(num/2)) start,floor(num/2+1) from( select job,count(1) num from grade group by job )t order b...

2024-02-19

0 219

题解 | #考试分数(三)#

select t.id,name,score from language join ( select id,language_id,score,dense_rank()over(partition by language_id order by score desc) rank_num ...

2024-02-19

0 255

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

with t2 as( select date from login group by date ) select date,sum(if(first_date = date,1,0)) from t2 left join login using(date) left join( s...

2024-02-18

0 190

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

select round(count(login.date)/count(1),3) from( select user_id,min(date) date from login group by user_id )t1 left join login on t1.user_id = log...

2024-02-18

0 225

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

select user.name u_n,client.name c_n,login.date from( select user_id,max(date) date from login group by user_id )t1 left join login on t1....

2024-02-18

0 225

题解 | #给出employees表first_name#

select first_name first from( select first_name,row_number()over(order by first_name) rm from employees )t right join employees using(first_name) ...

2024-02-18

0 222