Lateral

分类

/ 注册

全部文章（共102篇）

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

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

2025-06-26

0 23

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

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

2025-06-26

0 20

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

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

2025-06-26

0 21

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

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 20

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

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 21

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

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

2025-06-26

0 20

题解 | 考试分数(五)

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 15

题解 | 考试分数(四)

select distinct job, case when (count(*) over(partition by job))%2=1 then round(((count(*) over(partition by job))-1)/2+1,0) else round(((...

2025-06-26

0 15

题解 | 考试分数(四)

select distinct job, case when (count(*) over(partition by job))%2=1 then round(((count(*) over(partition by job))-1)/2+1,0) else round(((...

2025-06-26

0 18

题解 | 考试分数(四)

select distinct job, case when (count(*) over(partition by job))%2=1 then round(((count(*) over(partition by job))-1)/2+1,0) else round(((...

2025-06-26

0 13