笑一下a

分类

/ 注册

全部文章（共14篇）

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

SELECT video_id, ROUND((100 * finished_rate + 5 * like_cnt + 3 * comment_cnt + 2 * retweet_cnt) / (no_play_re...

2024-11-25

0 58

题解 | #国庆期间每类视频点赞量和转发量#

select * from( select tag, dt,sum(if_like) over(partition by tag order by dt asc rows 6 preceding) sum_like_cnt_7d, max(if_retweet) over(partition by ...

2024-11-25

0 52

题解 | #大小写混乱时的筛选统计#

select t3.tag,t4.answer_cnt from( select tag, count(start_time) answer_cnt from examination_info t1 left join exam_record t2 on t1.exam_id = t2.exam_i...

2024-11-20

0 35

题解 | #注册当天就完成了试卷的名单第三页#

select uid,level,register_time,max_score from( select t3.uid,level,register_time,max(score) max_score,row_number() over(order by max(score) desc) ran...

2024-11-17

0 48

题解 | #筛选限定昵称成就值活跃日期的用户#

select uid,nick_name,achievement from user_info where (uid in( select uid from exam_record where date_format(start_time,"%Y%m" ) = 202109) o...

2024-11-13

0 47

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

select uid,round(sum(if(score is null,0,score))/count(*),0) avg_score, round(sum(if(shijian is null,duration,shijian))/count(*),1) avg_time_look from...

2024-11-11

0 41

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

select uid,start_month,total_cnt,complete_cnt from( select uid,start_month,total_cnt,complete_cnt,dense_rank() over(partition by uid order by start_mo...

2024-11-08

0 44

题解 | #近三个月未完成试卷数为0的用户完成情况#

select uid,a1 exam_complete_cnt from( select uid,count(start_time) a1,count(submit_time) a2 from( select uid,exam_id,start_time,submit_time,dense_rank...

2024-11-08

0 46

题解 | #第二快/慢用时之差大于试卷时长一半的试卷#

select distinct exam_id,duration,release_time from( select exam_id, duration, release_time,sum(case when rank1 = 2 then dur when rank2 = 2 then -dur e...

2024-11-06

0 42

题解 | #满足条件的用户的试卷完成数和题目练习数#

select t3.uid,count(distinct case when year(t3.submit_time) = '2021' then t3.id else null end) as exam_cnt, count(distinct case when year(t4.submit_t...

2024-11-02

0 50