牛客851291063号

分类

/ 注册

全部文章（共15篇）

题解 | #查找字符串中逗号出现的次数#

用replace替换字符为空，然后计算前后字符串长度之差就行，不用想太复杂 select id, length(string)-length(replace(string,',','')) from strings

2024-08-14

0 139

题解 | #最长连续登录天数#

select cur_id user_id,format(max(cnt)+1,0) max_consec_days from( select if(@cur,@per:=@cur,@per:=null) per, @cur:=fdate cur, ...

2024-08-13

2 206

题解 | #获取指定客户每月的消费额#

select time,sum(t_amount) as total from( select t_id,substring(t_time,1,7) time,t_amount from trade,customer where c_name='Tom' and t_time...

2024-08-12

0 186

题解 | #每个月Top3的周杰伦歌曲#

select month,ranking,song_name,play_pvfrom( select month,row_number() over(partition by month order by play_pv desc) as ranking,song_name,play_...

2024-08-09

0 142

题解 | #牛客网用户没有补全的信息#

import pandas as pd data=pd.read_csv('Nowcoder.csv') b=pd.isna(data.iloc[0]) for i in range(1,data.shape[0]): s=pd.isna(data.iloc[i]) b=b|s ...

2024-05-16

0 187