烛少

分类

题解(53)

/ 注册

全部文章（共68篇）

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

select user_id,max(inter_num2) as max_consec_days from( select user_id,day-row_num as inter_num,count(day-row_num) inter_num2 from( select day(fdate)*...

2024-11-17

0 65

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

select * from( select month(a.fdate) as month, row_number() over(partition by month(a.fdate) order by count(b.song_name) desc,b.song_id asc ) as ranki...

2024-11-17

0 71

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

select month,ranking,song_name,play_pv from( select month,row_number() over(partition by month order by play_pv desc,song_id) as ranking,song_name,pla...

2024-11-17

0 56

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

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

2024-11-17

0 56

题解 | #浙大不同难度题目的正确率#

select difficult_level,sum(if(result='right',1,0))/count(result) correct_rate from question_practice_detail a,user_profile b,question_detail c where a...

2024-11-17

0 61

题解 | #统计复旦用户8月练题情况#

select b.device_id,university ,sum(if(month(a.date)=8,1,0)) question_cnt ,sum(if(month(a.date)=8 and result='right',1,0)) right_question_cnt from qu...

2024-11-17

0 53

题解 | #合并表记录#

n=int(input()) dic={} for i in range(n): k,v=[int(j) for j in input().split(" ")] dic[k]=dic.get(k,0) + v for key in sorted(dic): print(...

2022-04-26

0 285

题解 | #质数因子#

while True: try: num=int(input()) if num in [1,2]: print(num) # break for i in range(2,int(num**0....

Python3

2022-04-26

0 446

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

使用lead函数和dense_rank函数，这个方法写起来最简单也容易理解，而且运行效率还比较高（配合next_day!=date条件和dense_rank()函数，能解决重复登录问题;其他答案多使用row_number()函数，这是不正确的，配到重复登录情况必出错） select date, i...

Mysql

2022-04-02

0 388

题解 | 新登录用户次日成功的留存率

巧思：在group_concat(date)中找用户最找登录日期的下一天，如果能找到，那就标记为1，否则为0 select round(sum(t)/count(*),3) from (select user_id,if(FIND_IN_SET(date_add(min(date),interv...

Mysql

2022-04-02

1 497