zzzzzzy6_

分类

/ 注册

全部文章（共2篇）

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

select sum(course1)+sum(course2)+sum(course3) as staff_nums from (select info_id, staff_id, if(course like '%1%',1,0) as course1, if(...

2024-08-13

93 246

题解 | #最长连续登录天数#

select user_id, max(连续登录天数) as max_consec_days from (select user_id, max(日期排序)-min(日期排序)+1 as 连续登录天数 from (select user_id, fd...

2024-08-12

136 935