牛客815698333号

分类

题解(26)

/ 注册

全部文章（共23篇）

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

with t as(select * from order_info where date>'2025-10-15' and status='completed' and product_name in ('Python','Java','C++'))select t1.user_id,min...

2021-04-16

0 370

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

在（三）的基础上：with t as(select * from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Python','Java'))select user...

2021-04-15

0 329

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

第一种：select *from order_infowhere user_id in (select distinct user_id from order_info where date>'2025-10-15' and status='completed' and product_n...

2021-04-15

0 512

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

select user_idfrom order_infowhere date>'2025-10-15' and status="completed" and product_name in ("C++","Java","Python")group by user_idhaving count...

2021-04-13

0 277

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

select *from order_infowhere date>'2025-10-15' and status="completed" and product_name in ("C++","Java","Python")order by id;

2021-04-13

0 309

题解 | #考试分数(五)#

with t1 as (select * ,row_number() over(partition by job order by score desc) t_rankfrom grade)select t1.* from t1join (select job,floor((count()+1)/...

2021-04-13

0 272

题解 | #考试分数(四)#

select job ,start,endfrom (select job,if(count()%2=0,round(count()/2),round((count()+1)/2)) start,if(count()%2=0,round(count()/2+1),round((count()+1)/...

2021-04-13

0 365

题解 | #考试分数(三)#

1.内连接+dense_rank() over(...)窗口函数select id,name,scorefrom (select t1.*,t2.name,dense_rank() over(partition by t1.language_id order by t1.score desc) rk...

2021-04-13

0 378

题解 | #考试分数(二)#

内连接select id,t1.job,score from grade t1join (select job,avg(score) avg_score from grade t2 group by job ) t2 on t1.job=t2.jobwhere t1.score>t2.avg_...

2021-04-12

0 280

题解 | #牛客每个人最近的登录日期(六)#

select name u_n,t2.date date,(select sum(number) ps_num from passing_number t1 where t1.user_id=t2.user_id and t1.date<=t2.date)from passing_number...

2021-04-08

1 438