Lateral

分类

/ 注册

全部文章（共115篇）

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

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 32

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

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

2025-06-27

0 33

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

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 28

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

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

2025-06-26

0 35

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

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

2025-06-26

0 36

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

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

2025-06-26

0 32

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

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 29

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

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 33

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

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

2025-06-26

0 31

题解 | 考试分数(五)

with median_rows as(select job, floor((count(*)+1)/2) as start_row, floor((count(*)+2)/2) as end_row from grade group by job) select ...

2025-06-26

0 23