牛客768350767号

分类

/ 注册

全部文章（共17篇）

题解 | 每个部门薪资排名前两名员工

select department,employee_name,salary from(select department,employee_name,salary,row_number()over(partition by department order by salary desc) as r...

2025-07-07

0 15

题解 | 商品销售总额分布

select case when u.pay_method='' then 'error' else u.pay_method end as pay_method,count(distinct u.trace_id) as rk from user_client_log u join product...

2025-07-03

0 13

题解 | 每天登陆最早的用户的内容喜好

with l as( select user_id,date(log_time) as log_day,rank()over(partition by date(log_time) order by log_time) as rn from login_tb ) select log...

2025-06-09

0 25

题解 | 统计加班员工占比

with a as( select staff_id,round(timestampdiff(minute,first_clockin,last_clockin)/60,1) as time from attendent_tb) select department,concat(ro...

2025-06-09

0 25

题解 | 查询单日多次下订单的用户信息？

with o as ( select user_id, date (order_time) as order_date, count(*) as order_nums from ...

2025-06-06

0 20

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

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 28

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

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

2025-05-23

0 29