jl0427

分类

/ 注册

全部文章（共50篇）

题解 | #链表内指定区间反转#

# class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @para...

2023-11-01

0 176

题解 | #牛牛的三元组问题#

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

2023-10-22

0 241

题解 | #近三个月未完成试卷数为0的用户完成情况#

select uid,count(score) as exam_complete_cnt from( select *, dense_rank()over(partition by uid order by date_format(start_time,'%Y%m') desc) as rk fro...

2023-08-30

0 222

题解 | #近三个月未完成试卷数为0的用户完成情况#

select uid, count(score) as exam_complete_cnt from ( select *,dense_rank()over(partition by uid order by date_format(start_time,'%Y%m') desc) as rk fr...

2023-08-29

1 304

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

with t as (select level,score,count(level)over(partition by level) as level_cn, (case when score<60 then '差' when score<75 and score>=60 then...

2023-08-28

0 240

题解 | #大小写混乱时的筛选统计#

WITH t_tag_count as ( SELECT tag, COUNT(uid) as answer_cnt FROM exam_record LEFT JOIN examination_info USING(exam_id) GROUP BY tag ) ...

2023-08-27

1 261

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

select tag as tid,uid,ranking from ( select tag,exam_record.uid, row_number() over(partition by tag order by max(score) desc,min(score) desc,exam_reco...

2023-08-27

2 373

题解 | #分别满足两个活动的人#

(select uid,'activity1' as activity from exam_record where year(submit_time) = 2021 group by uid having min(score) >=85) union all (select distin...

2023-08-26

0 269

题解 | #未完成试卷数大于1的有效用户#

select uid, sum(if(submit_time is null,1,0)) as incomplete_cnt, sum(if(submit_time is not null,1,0)) as complete_cnt, group_concat(distinct CONCAT(DAT...

2023-08-25

1 379

题解 | #每天的日活数及新用户占比#

with t1 as( select distinct uid,date(in_time) dt,min(date(in_time))over(partition by uid) new_dt from tb_user_log union select distinc...

2023-07-20

1 235