牛客768350767号

分类

/ 注册

全部文章（共32篇）

题解 | 查询连续登陆的用户

with b1 as( select distinct user_id,date(log_time) as log_date,row_number()over(partition by user_id order by date(log_time)) as rn from login...

2025-05-27

0 48

题解 | 统计所有课程参加培训人次

select sum(length(course)-length(replace(course,',',''))+1) as staff_nums from cultivate_tb where course is not null

2025-05-23

0 36