牛客938846508号

分类

/ 注册

全部文章（共32篇）

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

#完播率 round(sum(if(end_time-start_time>=duration,1,0))/count(start_time),3) as avg_comp_play_rate select a.video_id, round(sum(if(end_time-sta...

2024-02-29

1 207

题解 | #统计每个学校各难度的用户平均刷题数#

select a.university, c.difficult_level, -- 平均刷题数 round(count(b.question_id)/count(distinct (b.device_id)),4) as avg_answer_cnt from question_practi...

2024-02-29

1 195