Tendernessnick

分类

/ 注册

全部文章（共114篇）

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

select date_format(submit_time,'%Y%m') as submit_month, count(submit_time) as month_q_cnt, round(count(submit_time)/day(avg(last_day(submi...

2025-10-30

0 18

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

# 零级用户高难度试卷平均得分平均用时 # 未完成的试卷按照最长时间和零分处理 select ui.uid, round(avg( case when er.score is null then 0 else er...

2025-10-30

0 16

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

select exam_id, count( case when score is null then 1 else null end ) as incomplete_cnt, round((count(...

2025-10-30

0 13

题解 | 试卷发布当天作答人数和平均分

select er.exam_id, count(distinct er.uid) as uv, round(avg(score),1) as avg_score from user_info as ui inner join exam_record ...

2025-10-29

0 19