牛客926165907号

分类

/ 注册

全部文章（共46篇）

题解 | 牛客的课程订单分析(五)

with tb1 as( select user_id, date, dense_rank() over( partition by user_id order by date ) as rk from order_info where dat...

2025-08-09

1 42

题解 | 牛客的课程订单分析(一)

select * from order_info where date > '2025-10-15' and status = 'completed' and product_name in ('C++', 'Java', 'Python') order by id

2025-08-08

1 44

题解 | 考试分数(五)

with tb1 as( select id, job, score, row_number() over( partition by job order by score desc ) as t_rank from grade ), tb2 ...

2025-08-07

0 36

题解 | 考试分数(三)

select id, name, score from( select grade.id, name, score, dense_rank() over( partition by language_id order by score desc ) a...

2025-08-06

0 35

题解 | 考试分数(二)

with tb1 as( select id, job, score, avg(score) over( partition by job ) as avgscore from grade ), tb2 as( select id, job, scor...

2025-08-06

0 52

题解 | 牛客每个人最近的登录日期(四)

with tb1 as( select user_id, date, rank() over( partition by user_id order by date ) as rk from login ), tb2 as( selec...

2025-08-05

0 32

题解 | 牛客每个人最近的登录日期(三)

with tb as( select count(distinct login.user_id) as i from login join login as login1 on login.user_id = login1.user_id and login.dat...

2025-08-05

0 43

题解 | 牛客每个人最近的登录日期(二)

select u_n, c_n, date from( select user.name as u_n, client.name as c_n, date, rank() over( partition by user_id order by date des...

2025-08-05

0 38

题解 | 牛客每个人最近的登录日期(一)

select user_id, date from( select *, rank() over( partition by user_id order by date desc ) as rk from login ) as tb where...

2025-08-04

0 25

题解 | 异常的邮件概率

select date, round(sum(cnt) / count(*), 3) as p from( select send_id, tb1.is_blacklist as send_id_check, receive_id, tb2.is_blacklist as rece...

2025-08-04

0 33