爆栈炸死各位爷
爆栈炸死各位爷
全部文章
分类
归档
标签
去牛客网
登录
/
注册
爆栈炸死各位爷的博客
全部文章
(共46篇)
题解 | #筛选昵称规则和试卷规则的作答记录#
SELECT a.uid uid, er.exam_id exam_id, ROUND(avg(er.score), 0) avg_score FROM exam_record er INNER JOIN ( SELECT ...
2023-11-09
0
82
题解 | #筛选限定昵称成就值活跃日期的用户#
select uid, nick_name, achievement from user_info where nick_name like '牛客%号' and achievement BETWEEN 1200 and 2500 and ( ...
2023-11-08
0
56
题解 | #0级用户高难度试卷的平均用时和平均得分#
select er.uid, ROUND(avg(if (er.score is null, 0, er.score)), 0) avg_score, ROUND( avg( if ( submit_ti...
2023-11-08
0
73
题解 | #统计有未完成状态的试卷的未完成数和未完成率#
select exam_id, SUM(if (submit_time is null, 1, 0)) incomplete_cnt, ROUND(SUM(if (submit_time is null, 1, 0)) / count(*), 3) complete_rate...
2023-11-08
0
70
题解 | #每个6/7级用户活跃情况#
SELECT ui.uid uid, IF (c.act_month_total IS NULL, 0, c.act_month_total) act_month_total, IF (pp.act_days_2021 IS NULL, 0, pp.act_days_2021...
2023-11-07
0
109
题解 | #满足条件的用户的试卷完成数和题目练习数#
SELECT a.uid, IFNULL (a.exam_cnt, 0) exam_cnt, IFNULL (b.question_cnt, 0) question_cnt FROM ( SELECT uid, ...
2023-11-06
0
76
首页
上一页
1
2
3
4
5
下一页
末页