牛客938846508号

分类

/ 注册

全部文章（共32篇）

题解 | #未完成率较高的50%用户近三个月答卷情况#

#建立临时表查询SQL试卷上未完成率较高的50%用户 with t1 as #用户表 (select a.uid from (select uid ,percent_rank()over(order by(sum(if(score is null,1,0))/count(e...

2024-06-13

0 228

题解 | #国庆期间近7日日均取消订单量#

select dt ,round(finish_num_7d,2) as finish_num_7d ,round(cancel_num_7d,2) as cancel_num_7d from (select dt ,avg(s1)over(order by dt rows ...

2024-06-04

0 208

题解 | #近一个月发布的视频中热度最高的top3视频#

select video_id ,round(((100*视频完播率+5*点赞数+3*评论数+2*转发数)*新鲜度),0) as hot_index from( select a.video_id ,avg(if(timestampdiff(second,start_time...

2024-05-19

1 237

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

select b.id ,b.name ,c.总积分 from (select user_id ,总积分 ,dense_rank()over(order by 总积分 desc) as de_rk from (select us...

2024-05-14

0 166

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

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

2024-05-13

0 136

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

#初版 select a.user_id ,b.first_buy_date ,a.second_buy_date ,b.cnt from (select #求second_buy_date user_id ,date as second_buy_date from...

2024-05-07

0 212

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

select a.user_id ,b.first_buy_date ,a.second_buy_date ,b.cnt from (select #求second_buy_date user_id ,date as second_buy_date from ...

2024-05-07

0 221

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

#嵌套 select b.id ,b.job ,b.score ,b.t_rank from (select id ,job ,score ,row_number()over(partition by job order by score desc)as t_...

2024-05-06

0 187

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

#本人愚解 select job ,case when mod(count(job),2)=1 then round(count(job)/2,0) when mod(count(job),2)=0 then floor(count(job)/2) end as start , case when...

2024-05-05

0 194

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

select round(sum(if(date=date_add(fv,interval 1 day),1,0)) /count(distinct a.user_id),3) as p from (select user_id ,date ,first_value...

2024-05-04

1 120