Tendernessnick

分类

/ 注册

全部文章（共114篇）

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

with t1 as( select oi.id as id, user_id, count(user_id)over(partition by user_id) as course_cnt, product_name, ...

2025-11-07

0 15

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

with t1 as( select oi.id as id, user_id, count(user_id)over(partition by user_id) as course_cnt, product_name, ...

2025-11-07

0 16

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

with t1 as( select user_id, count(user_id)over(partition by user_id) as course_cnt, date, dense_rank()over(partiti...

2025-11-07

0 18

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

with t1 as( select user_id, date, dense_rank()over(partition by user_id order by date) as date_rank, count(user_id...

2025-11-07

0 15

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

with t1 as( select user_id, product_name, status, date, count(status)over(partition by user_id) as counts ...

2025-11-07

0 25

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

with t1 as( select user_id, product_name, status, date, count(status)over(partition by user_id) as counts ...

2025-11-07

0 19

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

# 成功购买 c++或者java或者python id排序 select * from order_info where status='completed' and product_name in('C++','Java','Python') and...

2025-11-07

0 20

题解 | 考试分数(五)

with t1 as( select id, job, score, dense_rank()over(partition by job order by score desc) as t_rank, count...

2025-11-07

0 17

题解 | 考试分数(四)

with t1 as( select job, floor((count(*)+1)/2) as start, ceiling((count(*)+1)/2) as end from grade group by...

2025-11-07

0 18

题解 | 考试分数(三)

# 每个岗位排名前2 with t1 as( select grade.id as id, name, score, dense_rank()over(partition by name order by score desc)...

2025-11-07

0 14