秋天的震撼已经感受到了😅😅😅

分类

/ 注册

全部文章（共80篇）

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

select job,sum(num) count from resume_info where date>'2025-01-01' and date<'2025-12-31' group by job order by sum(num) desc

2023-12-08

0 236

题解 | 读题

select source,count(source) cnt from(select case when is_group_buy='Yes' then 'GroupBuy' else name end source from(select * from(select *,count(user_i...

2023-12-07

0 277

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

select t1.id id,is_group_buy,name client_name from(select * from(select *,count(user_id)over(partition by user_id) cn from order_info where date>'2...

2023-12-07

0 271

题解 | 丝滑

select t1.user_id user_id,t1.date first_buy_date,t2.date second_buy_date,t1.cn cnt from(select user_id,product_name,date,cn from(select *,row_number()...

2023-12-07

1 230

题解 | 丝滑享受一气呵成

select user_id,date first_buy_date,c cnt from(select *,row_number()over(partition by user_id order by date) rn from(select *,count(user_id)over(partit...

2023-12-07

1 283

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

select id,t1.user_id user_id,product_name,status,client_id,date from (select id,user_id,product_name,status,client_id,date from order_info where date&...

2023-12-07

0 188

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

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

2023-12-07

0 218

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

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

2023-12-07

0 215

题解 | %返回余数

select job,case when c%2=0 then round(c/2) else round((c+1)/2) end start,case when c%2=0 then round(c/2+1) else round((c+1)/2) end end from(select job...

2023-12-06

0 196

题解 | 丝滑极致享受

select id,t1.job job,score,rn t_rank from(select id,job,score,row_number()over(partition by job order by score desc) rn from grade) t1 left join (sel...

2023-12-06

0 169