木流_牛马

分类

/ 注册

全部文章（共27篇）

题解 | 商品价格排名

#type diff #top 2 #huizong top3 with t1 as( select product_id,product_name,type,price,rank() over (partition by type order by price desc) as rank...

2025-10-17

0 15

题解 | 商品销售总额分布

#anta # every pay methode number distribution desc with t1 as (select ul.*,pi.price,pi.product_name, case when ul.pay_method='' and ul.step='select' t...

2025-10-17

0 13

题解 | 平均播放进度大于60%的视频类别

#diff / sec group by category #having > 60% #concat(round (..,2),"%") # desc with t1 as( select tu.video_id, tv.tag, case when(...

2025-09-14

0 21

题解 | 最长连续登录天数

#20230101-20230131 #max #lianxudenglu with t1 as ( select *,row_number() over (partition by td.user_id order by td.fdate) as rn from tb_dau td)...

2025-09-14

0 24

题解 | 牛客直播开始时各直播间在线人数

#19;00 在线人数 #per subject #asc course id select ct.course_id, ct.course_name,count(distinct at.user_id) as online_num from attend_tb at join course_tb...

2025-04-22

0 65

题解 | 2021年11月每天新用户的次日留存率

#2021 11 #新用户 #第二天是否回来--->datediff=1 #跨天也行--> union with tnew as ( select distinct t.uid, date(in_time) as regtime from tb_user_log t ...

2025-04-22

0 35

题解 | 最长连续登录天数

#20230101-20230131 #max #lianxudenglu with trn as ( select fdate, user_id, row_number() over(partition by user_id order by fdate asc) as rn ...

2025-04-22

0 57

题解 | 国庆期间每类视频点赞量和转发量

# 10.01 guo qin tou san tian #by tag by day sum(like) from previous 7 days max(retweet) from previous 7 days # tag desc # day asc #t1 统计每天的每个视频的点赞和转...

2025-04-18

1 46

题解 | 各个视频的平均完播率

#2021 #有播放 #完播率 diff>= shiping shichang by shiping #round 3 #desc with t1 as( select t.*,(case when timestampdiff(second,t.start_time,t.end_t...

2025-04-18

0 48

题解 | 牛客用户刷题量的方差与提交次数的标准差

import sys import pandas as pd for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1])) df=pd.read_csv('Nowcoder.csv') print(round...

2025-04-15

0 46