Lateral

分类

/ 注册

全部文章（共146篇）

题解 | 最差是第几名(二)

WITH final_ranks AS ( SELECT grade, total_num, end_rank, COALESCE(LAG(end_rank) OVER(ORDER BY grade ASC), 0) + 1...

2025-06-30

0 42

题解 | 最差是第几名(一)

select t1.grade, sum(t1.number) over(order by t1.grade asc rows between unbounded preceding and current row) as t_rank from (select * from cla...

2025-06-27

0 49

题解 | 实习广场投递简历分析(三)

with month_info as( select job,date,num, substr(date,1,7) as mon from resume_info), t1 as( se...

2025-06-27

0 56

题解 | 实习广场投递简历分析(二)

select t1.job, concat('2025-',t1.mon) as mon, sum(t1.num) as cnt from (select job, num, substr(date,6,2) as mon from resume_in...

2025-06-26

0 43

题解 | 实习广场投递简历分析(一)

select job, sum(num) as cnt from resume_info where date like '2025%' group by job order by cnt desc

2025-06-26

0 65

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

with t as( select t1.* from order_info t1 inner join (select user_id from order_info where sta...

2025-06-26

0 52

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

with t as( select t1.* from order_info t1 inner join (select user_id from order_info where sta...

2025-06-26

0 60

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

with t3 as( select t1.*, dense_rank() over(partition by t1.user_id order by t1.date asc) as dtrank from order_info t1 inne...

2025-06-26

0 47

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

select t3.user_id, min(t3.date) as first_buy_date, count(id) as cnt from (select t1.* from order_info t1 inne...

2025-06-26

0 49

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

select t1.* from order_info t1 inner join (select user_id from order_info where status='completed' ...

2025-06-26

0 63