GuaMiao

分类

/ 注册

全部文章（共92篇）

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

with t1 as ( select uid, register_time from user_info where job = '算法' ), t2 as ( select a.uid, a.exam_id, a.start_time, a.submit_time...

2023-08-13

0 393

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

# 先找到昵称符合条件的用户uid with t1 as ( select uid, nick_name, achievement from user_info where nick_name REGEXP '^牛客[0-9]*号$' and achievement ...

2023-08-13

0 409

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

# 先找出完成过试卷的用户uid with t1 as ( select a.uid, b.level, a.score from exam_record as a left join user_info as b on a.uid = b.uid ), # 将各个分...

2023-08-13

0 434

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

with t1 as ( select uid from user_info where nick_name REGEXP '^牛客[0-9]*号$' or nick_name REGEXP '^[0-9]+$' ), t2 as ( select exam_...

2023-08-11

0 439

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

select exam_id, sum(score is null) as incomplete_cnt, round(sum(score is null)/count(*), 3) as incomplete_rate from exam_record group by exam_id hav...

2023-08-11

1 356

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

with t1 as ( select a.uid, a.exam_id, a.score, b.tag from exam_record as a left join examination_info as b on a.exam_id = b.exam_id ),...

2023-08-10

0 397

题解 | #每个题目和每份试卷被作答的人数和次数#

with t1 as ( select exam_id as tid, count(distinct uid) as uv, count(uid) as pv from exam_record group by tid order by uv desc, pv des...

2023-08-04

0 349

题解 | #作答试卷得分大于过80的人的用户等级分布#

with t as ( select uid, a.exam_id, b.tag, score from exam_record as a left join examination_info as b on a.exam_id = b.exam_id ) sele...

2023-08-04

0 339

题解 | #统计作答次数#

select count(start_time) as total_pv, count(score) as complete_pv, count(distinct case when score is null then null else exam_id end) as complete_exam...

2023-08-03

0 417

题解 | #寻找峰值#Python

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param nums int整型一维数组 # @return int整型 # class Solution: def findPeakElement(self , nums: List[int...

2023-08-03

0 374