牛客768350767号

分类

/ 注册

全部文章（共32篇）

题解 | 更新员工信息表

with u1 as( select EMPLOYEE_ID,UPDATE_DT,NEW_POSITION,row_number()over(partition by EMPLOYEE_ID order by UPDATE_DT desc) as rk from EMPLOYEE_U...

2025-07-10

0 34

题解 | 未下单用户登陆渠道统计

with u as( select distinct uid,channel from user_info where uid not in (select uid from order_log)) select channel,count(*) as cnt from u grou...

2025-07-10

0 31

题解 | 未下单用户统计

select count(distinct uid) as count from user_info where uid not in (select distinct uid from order_log)

2025-07-09

0 31

题解 | 每个顾客购买的最新产品名称

with o as( select customer_id,product_id,row_number()over(partition by customer_id order by order_date desc) as rk from orders) select o.c...

2025-07-09

0 25

题解 | 查询订单

with o as( select order_id,customer_id,order_date,row_number()over(partition by customer_id order by order_date desc) as rk from orders) select o.orde...

2025-07-08

0 43

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

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 35

题解 | 商品销售总额分布

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 35

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

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 46

题解 | 统计加班员工占比

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 49

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

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

2025-06-06

0 36