会编程的发呆爱好者加麻加辣

分类

/ 注册

全部文章（共208篇）

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

select h1.job, h1.first_year_mon,h1.cnt as first_year_cnt, h2.second_year_mon,h2.cnt as second_year_cnt from (select job,substr(date,1,7) as first_yea...

2025-03-28

0 26

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

select job,substr(date,1,7) as mon, sum(num) as cnt from resume_info where year(date) =2025 group by job,substr(date,1,7) order by mon desc,cnt desc 简...

2025-03-27

0 32

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

select job,sum(num) as cnt from resume_info where year(date) =2025 group by job order by cnt desc 简单

2025-03-27

0 29

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

select (case when d.is_group_buy ='No' then c.name else 'GroupBuy' end) as source, count(*) as cnt from (select b.is_group_buy,b.clie...

2025-03-27

0 27

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

select d.id,d.is_group_buy, (case when d.is_group_buy ='No' then c.name else NULL end) as client_name from (select b.client_id,b.id,b.is_gro...

2025-03-26

0 39

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

select b.user_id,b.first_buy_date,c.second_buy_date,b.cnt from (select distinct a.user_id, date as first_buy_date, num as cnt from ( select user_i...

2025-03-26

0 32

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

select distinct a.user_id, date as first_buy_date, num as cnt from ( select user_id,count(*) over(partition by user_id ) as num, row_number() ...

2025-03-26

0 26

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

select a.id,a.user_id,a.product_name,a.status,a.client_id,a.date from ( select user_id,id,product_name,status,client_id,d...

2025-03-25

0 35

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

select distinct a.user_id from ( select user_id,count(*) over(partition by user_id ) as num from order_info where date>'2025-10-15' ...

2025-03-25

0 34

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

select id,user_id,product_name,status,client_id,date from order_info where date > '2025-10-15' and status ='completed' and (product_name ='C++' or...

2025-03-25

0 26