python之王

分类

/ 注册

全部文章（共38篇）

题解 | #获得积分最多的人(二)#

select distinct(id), name, grade_num from ( select id, name, grade_num, max(grade_...

2023-12-20

0 173

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

select b.job, first_year_mon, first_year_cnt, second_year_mon, second_year_cnt from ( select job, ...

2023-12-15

0 205

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

select name as source, count(*) as cnt from ( select *, ( case when is...

2023-12-13

0 190

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

select user_id, min(date) as first_buy_date, max(date) as second_buy_date, cnt from ( select *, co...

2023-12-13

0 163

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

select user_id, date as first_buy_date, cnt from ( select *, count(product_name) over (partition by us...

2023-12-13

0 169

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

select id, a.job, score, t_rank from (select id, job, score, row_number() over(partition by job o...

2023-12-13

0 168

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

select job, floor(if(count(*)%2=0, count(*)/2, (count(*)+1)/2)) as start, floor(if(count(*)%2=0, count(*)/2+1, (count(*)+1)/2)) as end fr...

2023-12-13

0 195

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

select name, date, sum(number) over(partition by user_id order by date) as 'cum_cnt' from passing_number p, user u where p.user_...

2023-12-12

0 170

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

select b.date, if(round(cnt2 / cnt1, 3)>0,round(cnt2 / cnt1, 3),0.000) as p from ( select distinct date, ...

2023-12-11

0 192

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

select date, sum(is_new_user) as new from ( select id, l.user_id, client_id, date,...

2023-12-11

0 199