Bubble2016

分类

题解(21)

/ 注册

全部文章（共17篇）

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

with rowrank as ( select *, count(id) over(partition by user_id) as tcount, row_number() over(partition by user_id) as trank from orde...

Mysql

2021-09-21

0 278

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

with rr as ( select *, count(id) over(partition by user_id) as cnt, row_number() over(partition by user_id order by date ) as t_rank fr...

Mysql

2021-09-21

0 347

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

select user_id, min(date)as first_buy_date , count(id) as cnt from order_info where date > '2025-10-15' and product_name in ('C++','Java','Python')...

Mysql

2021-09-21

0 310

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

select id,user_id,product_name,status,client_id,date from (select *,count(id) over(partition by user_id) as trank from order_info where status = 'comp...

Mysql

2021-09-21

0 283

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

select distinct(user_id) from (select *,row_number() over(partition by user_id order by product_name) as trank from order_info where status = 'complet...

Mysql

2021-09-21

0 336

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

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

Mysql

2021-09-21

0 288

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

with rowrank as ( select *, count(id) over(partition by user_id) as tcount, row_number() over(partition by user_id) as trank from orde...

Mysql

2021-09-21

0 318