牛客466955756号

分类

/ 注册

全部文章（共29篇）

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

select video_id,round(sum(if(vt >= duration,1,0))/count(1),3) as avg_comp_play_rate from (select t.video_id, timestampdiff(second, start_time, end_...

2025-06-01

0 56

题解 | 更新员工信息表

select ei.EMPLOYEE_ID, case when LAST_UPDATE_DT > UPDATE_DT then POSITION else NEW_POSITION end as POSITION, case when LAST_UPDATE...

2025-05-31

0 72

题解 | 未下单用户登陆渠道统计

select channel ,count(uid) as cnt from user_info where uid not in (select uid from order_log) group by channel order by cnt desc,channel limit 1;

2025-05-31

0 59

题解 | 商品id数据清洗统计

select a.pd as product_id ,count(a.pd) as cnt from (select substring_index(order_id,'_',-1) as pd from order_log) a group by a.pd order by cnt desc li...

2025-04-20

0 49

题解 | 任意两个连续自然月练题次数大于1的用户

select device_id from ( select a.device_id, n from ( select ...

2025-02-24

0 68

题解 | 各年级学生的平均绩点

select case when y=2022 then '大四' when y=2023 then '大三' when y=2024 then '大二' when y=2025 then'大一' end as grad...

2025-02-24

0 70

题解 | 月总刷题数和日均刷题数

select date_format (submit_time, '%Y%m') as submit_month, count(1) as month_q_cnt, round(count(1) / ( case when max(m...

2025-02-20

0 80

题解 | SQL类别高难度试卷得分的截断平均值

select tag, difficulty, round( (sum(score) - min(score) - max(score)) / (count(score) -2), 1 ) as clip_avg_score from ...

2025-02-20

0 112

题解 | 统计快递运输时长

select exp_type,round(avg(timestampdiff(minute,out_time,in_time)/60),1) as time from express_tb et join exp_action_tb eat on et.exp_number=eat.exp_num...

2025-02-20

0 77

题解 | 完成员工考核试卷突出的非领导员工

select ei.emp_id, emp_level,tag as exam_tag from emp_info ei join (select emp_id, a.exam_id from exam_record er, ...

2025-02-20

0 75