拒绝996的小蜗牛很自信

分类

/ 注册

全部文章（共20篇）

题解 | 统计快递从创建订单到发出间隔时长

select round(avg(timestampdiff(MINUTE,create_time,out_time)/60 ) ,3) as time from( select t1.create_time, t2.out_time from express_tb t1 left join exp...

2025-03-05

0 38

题解 | 统计快递运输时长

select t1.exp_type, round(avg(timestampdiff(second,t2.out_time,t2.in_time)/3600),1) as time from express_tb t1 left join exp_action_tb t2 on t1.exp_nu...

2025-03-05

0 36

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

with t2 as( select user_id , date as first_buy_date from ( select user_id, date, rank()over(partition by user_id order by date) as rank1 from order_i...

2024-08-18

0 127

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

with t1 as( select user_id, sum(case when type = 'add' then grade_num else -1*grade_num end) as sum_grade from grade_info group by user_id ), t2 as( ...

2024-08-18

0 101

#回答过教育类问题的用户里有多少用户回答过职场类问题#

with t1 as( select author_id,issue_id from answer_tb where issue_id in (select issue_id from issue_tb where issue_type = 'Education' ) ), t2 as ( sele...

2024-08-13

0 134

题解 | #平均播放进度大于60%的视频类别#

with t1 as ( select video_id,tag, case when timestampdiff(second,start_time,end_time)<duration then timestampdiff(second,start_time,end_time)/durat...

2024-08-13

0 110

题解 | #各个视频的平均完播率#

with t1 as( select video_id, timestampdiff(second,start_time,end_time) as take_time from tb_user_video_log where year(start_time) = 2021 ) select vide...

2024-08-13

0 106

题解 | #筛选昵称规则和试卷规则的作答记录#

select uid, exam_id, round(avg(score),0) as avg_score from exam_record where uid in (select uid from user_info where nick_name rlike '^牛客[0-9]+号$' or ...

2024-08-11

0 167

题解 | #0级用户高难度试卷的平均用时和平均得分#

with t1 as ( select uid, score, duration, submit_time,start_time from user_info join exam_record using(uid) join examination_info using(exam_id) wher...

2024-08-11

0 125

题解 | #统计有未完成状态的试卷的未完成数和未完成率#

select exam_id, sum(if (submit_time is null, 1, 0)) as incomplete_cnt, round(sum(if (submit_time is null, 1, 0))/count(start_time),3) as complete_rat...

2024-08-11

0 139