纯真的我求求offer

分类

/ 注册

全部文章（共40篇）

题解 | #每类试卷得分前3名#

with tmp as ( select distinct tag tid, uid, -- score, max(score) over(partition by tag,uid ) max_score, min(score) over(partition by tag,uid ) min_s...

2023-09-05

0 289

题解 | #筛选昵称规则和试卷规则的作答记录#

select a.uid, a.exam_id, format(avg(a.score),0) avg_score from exam_record a left join user_info b on a.uid=b.uid left join examination_info c on a...

2023-09-05

0 301

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

select uid, format(avg(score),0) avg_score, format(avg(timestampdiff(minute,start_time,submit_time)),1) avg_time_took from ( select a.uid, c.start...

2023-09-05

0 239

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

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

2023-09-05

0 344

题解 | #各用户等级的不同得分表现占比#

select c.level level, c.score_grade score_grade, format(count(1)/c.level_cn,3) ratio from ( select b.uid, b.exam_id, b.score, a.level, case when...

2023-09-04

0 320

题解 | #各用户等级的不同得分表现占比#

select c.level level, c.score_grade score_grade, format(count(1)/d.lev_count,3) ratio from ( select b.uid, b.exam_id, b.score, a.level, case whe...

2023-09-04

0 249

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

select distinct a.uid, a.nick_name, a.achievement from user_info a left join exam_record b on a.uid=b.uid left join practice_record c on a.uid=c.ui...

2023-09-04

0 243

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

select a.uid, level, register_time, max(score) max_score from user_info a, examination_info b, exam_record c where a.uid=c.uid and c.exam_id=b.exam_i...

2023-09-04

0 270

题解 | #注册时间最早的三个人#

select uid, nick_name, register_time from user_info order by register_time limit 3

2023-09-03

0 201

题解 | #注册时间最早的三个人#

select uid, nick_name, register_time from user_info where register_time<=( select register_time from user_info order by register_time limit 2,...

2023-09-03

0 188