.201901272010338

分类

题解(2)

/ 注册

全部文章（共11篇）

题解 | #得分不小于平均分的最低分#

select min(score) as min_score_over_avg from ( select score, avg(score) over ( partition by ...

2024-05-27

0 127

题解 | #统计作答次数#

select sum(if(start_time is not null,1,0)) total_pv, sum(if(submit_time is not null,1,0))complete_pv, count(distinct (if(score is not null,1,0 ))) com...

2024-05-27

0 109

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

with l1 as ( select exam_id, tag, difficulty from examination_info where ...

2024-05-27

0 113

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

select tag,difficulty, round( (sum(score)-max(score) - min(score))/(count(score) - 2) ,1) from (select e_i.exam_id,e_i.tag,e_i.difficulty,e_r.scor...

2023-05-22

0 189

题解 | #统计作答次数#

select count(uid) as total_pv ,count( case when submit_time is not null and score is not null then uid else null end ) as com...

2023-05-22

0 183

题解 | #不同学校类型的三日留存率#

select school_type ,sum(3daycnt)/sum(uidcnt) as trdaysfrom ad_channel_register_retention_uidgroup by 1order by 2 desc

2023-05-22

0 191

题解 | #三日留存和七日留存#

select sum(3daycnt)/sum(uidcnt) as trdays, sum(7daycnt)/sum(uidcnt) as sedaysfrom ad_channel_register_retention_uidwhere from_put = 'Oppo' group ...

2023-05-22

0 268

题解 | #验证刷题效果，输出题目真实通过率#

/* question_pass_rate ：每个用户不同题目的通过率，同一用户同一题重复提交通过仅计算一次 = 通过的题目总数/总题目数通过的题目总数：distinct if(result_info = 1, question_id,null) 总题目数：distinct question_i...

2023-05-21

0 754

题解 | #输出提交且通过次数大于2 的用户ID且升序排列#

select user_id from done_questions_record where result_info > 0 group by 1 having count(result_info) > 2 order by 1

2023-05-21

0 223

题解 | #浙江大学用户题目回答情况#

select device_id,question_id,result from question_practice_detailwhere device_id=(SELECT device_id from user_profile where university = '浙江大学')order b...

2021-08-26

7 747